If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Messages posted by: amber222
Forum Index » Profile for amber222 » Messages posted by amber222
Author Message
Admin, General Settings, Under Table, Font and Color Settings, Table background color

What template are you using?

http://proxy2.de/forum/viewtopic.php?p=10026&highlight=#10026
If you have PhpMyAdmin, you can try this. Save the old database from the old server to your hard drive as a .sql file. Then use that .sql file (instead of the guestbook.sql file included in the program) to populate a newly created database on the new server.

  • 1. On the old server, go into your Admin Panel, then PhpMyAdmin,
    and Export the .sql file of your existing database to your hard drive:

    [list:ddce079862] On the left (blue) pane, click in the database box and Select the guestbook's database

    When it finishes loading, on the right pane, click on the "Export" tab

    When it finishes loading, (somewhere towards the bottom) you will see:

    (checkbox) Save as file File name template: (remember template )*

    You must check the box for Save as file, then click on the GO button

    Follow the prompts to save it to your hard drive or other disk. Remember where you put the file. This is a backup of your existing database. Try not to mix it up with any other .sql files from a new copy of version 2.3.1. Alternatively, you could add something in the box after _DB_ to identify it, example: Save as file File Name template: _DB_old or _DB_date. The saved copy will automatically include the host's required user prefix, if any and the database name.


  • 2. On the new server, go to PhpMyAdmin and create a new guestbook database. (Be sure to add the required info in admin/config.inc.php and set file permissions according to the instructions in the readme file)

    3. In PhpMyAdmin, populate the new database:

  • As in #1 above, select the new guestbook's database in the left pane.

    On the right window pane, click on the "SQL" tab

    Find the Sql box (somewhere near the bottom?), click inside the box, then click on "browse" and navigate to the place on your hard drive where you put the .sql file you created earlier. Once you have navigated to that file and it is shown in the box, click on ok.

    After processing the task, you should get a successful result. If successful, the guestbook tables will appear in the left (blue) pane.

    If there is a problem, you will get an error message. If you get an error message, please make note of it for future help.


  • 4. On the left (blue) pane, click on Home

    5. On the right pane, select log out

    6. Close out the PhpMyAdmin window without navigating anywhere else (for security reasons)[/list:u:ddce079862]

    Typing this now from memory without any visual aids, so be careful.
    http://proxy2.de/forum/viewtopic.php?t=3423
    The problem is with the database. If you upgrade from 2.2, the table information is different. If you have always used 2.3.1, the tables are probably corrupt. Either way, you should fix the database tables instead of reverting back to an older file.
    Carbonize wrote:Damn this thread makes it look like I need a life


    This is your life.
    Kansas, are you using version 2.3.1?
    Trevor Wrote:
    Someone else had problems changing the drop down menu - check out the posts here, it may help...

    http://proxy2.de/forum/viewtopic.php?t=3174

    There's another post with instructions - see if this works...

    http://proxy2.de/forum/viewtopic.php?t=2866
    Hey, I just noticed - I used to be your neighbor!

    Before returning to Michigan a few years ago to take care of my Mom, I lived and worked right there in Sherman Oaks! My office was in the Galleria, and I lived just a few blocks down on Sepulveda Blvd between Ventura and Burbank Bl.

    It's a small world after all.
    This is the "Admin loop" several people have experienced.

    Did you recently upgrade from 2.2? This will cause the loop, because the database tables aren't quite the same.

    You can read up on the Admin loop and figure out the best way for you to resolve it. One solution is to revert back to a file from version 2.2, but I don't believe this is the responsible approach.

    If, as you say, the situation is urgent, the quickest way would be to delete the entries from the data table in PhpMyAdmin now, and then read the posts and fix the problems later.

    I don't recall the thread address, but find a recent post from me about "Advanced Guestbook fixes and mods". In there it gives the link to the thread about the Admin loop. When you read that thread, also read Jam's instructions for fixing the db tables, and see if that is your problem.
    Anonymous wrote:i am sorry, but i dont know what form he is speaking of, and what commenting out means. i am somewhat of a novice...

    please anyone?? i really need the assistance on how to remove the 'number of votes' from displaying.

    It is very easy to find information about things you don't know just by visiting Google.com and typing it in a search box. For instance, if you search for "comment out" on Google, you will probably get thousands of results. You should always do a search, either on the forum or on Google, before you post a question.

    Here's a site that explains commenting out: http://www.htmlite.com/php006.php -
    I hope you will read it.

    Here is one of their examples:
  • // This is an example of commenting.

    # This is also an example of commenting.

    echo "This text will appear on the web page. <br />";

    // echo "This text will not appear.";

    echo "Some more example text."; // That prints, not this.
    Commenting more than one line of coding is done using /* and */. Everything between these two tags will be commented. They can be used on a single line to many lines.

  • So, you would comment out code instead of deleting it, so it is there if you make a mistake or if you decide later you want to use it again.
    I actually figured out how to do this myself. Thanks to another post.

    I was able to go into the template and comment out the total number of votes display in the display footer template.

    I have not tried this myself, but I believe they are speaking of the Admin Panel, "Templates", "Poll Result", "result_foot". You want to get rid of the code that references the total votes.

    Before doing anything, you should make sure you read Auron's instructions. Search for poll instructions, and you will find his thread for "new" instructions. In it, he also mentions another thread you should read.

    Good luck.
    The comments page will stand on its own and not look like the rest of the site but I'm sure it doesn't matter too much


    You've lost me. The comments are posted directly under the guestbook entries. Just like on your test entry. My comment and yours are underneath it.

    Anyway, the real pros (Auron, Carbonize, Trevor, Jam'n, JTD) must be either on vacation or busy, but they will be back (we all had better hope), and I'm sure they can help you this weekend or next week.

    Hey, I really like that design!
    Deleted that entry. However, they will be back for sure - probably before the day is out. You should upgrade right away.

    Private Messaging is disabled here, so how shall I send you the details?
    Working on something now... Will look at it in about 30 min and get back to you.
    I think the comment feature is in the templates/entry.php file. You could comment out the following code.

    So what if you need to comment on something in the future? I can understand your reluctance to start over, but you really should consider putting the files back the way they were and just changing the header.

    Couldn't you also put a password requirement on the comments (from Admin General Settings) so no one can leave a comment except the Admin. That error only shows up when the comment is submitted.
    I'm not sure that's possible without customization. I think the comment feature was designed to be used by the site Administrator. In the Admin Panel there is a place to designate whether a password is necessary to make a comment. Maybe a password should be set and all persons allowed to comment have the password access. Different commentors can just sign their name or ID or some identifying info. Otherwise, if you are interested in seeing if this can be customized, I suggest you check with Carbonize. He'll be back on Saturday.
     
    Forum Index » Profile for amber222 » Messages posted by amber222
    Go to:   
    Based on the open source JForum