Announcement

Collapse
No announcement yet.

Blog stoppped working after moving to a new server

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • ceho
    replied
    Problem solved after re-setting the cookie domain. Sorry and thanks a lot anyway!

    Leave a comment:


  • ceho
    replied
    I attached a screenshot.

    Hope you can find something. All this appears so weird to me, as actually only the server environment changed...
    Attached Files

    Leave a comment:


  • Steve Machol
    replied
    Same error?

    Run 'Suspect File Version' in Diagnostics and report back the results.

    Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

    Leave a comment:


  • ceho
    replied
    I jut found out that when I try to see a member's profile, I get database erros as well and the forum's style is destroyed. Could there be a connection?

    The forum has been running on that database since one week and everything was fine, only now where I use the files from the server (domain was transferred only today) the problems occurr.

    Leave a comment:


  • ceho
    replied
    I did, still the same. Everything else is working.

    Leave a comment:


  • Zachery
    replied
    Run a repair on your tables, see if the products and plugins are all active and otherwise working.

    Leave a comment:


  • ceho
    replied
    Backup of the forum content and the database. Dump (mSQLdumper) of the database on the new server, upload of all files, editing the config.php, run tools.php and so far it all worked fine, I think. I hope!

    Leave a comment:


  • Zachery
    replied
    How did you move to the new server?

    Leave a comment:


  • ceho
    started a topic Blog stoppped working after moving to a new server

    Blog stoppped working after moving to a new server

    Hi, today I finished the move to a new server. Everything went well so far and is working properly.

    However, the Blog is not available anymore. The pulldown menu in the navbar is not popping up, and I received this strange database error message:

    Database error in vBulletin 3.8.3:

    Invalid SQL:

    SELECT
    user.username,
    blog.userid, blog.title, blog.blogid, blog.categories, blog.postedby_username, blog.postedby_userid,
    bu.title AS blogtitle, bu.options_guest & AS guestcanview
    FROM vb_blog AS blog
    LEFT JOIN vb_blog_user AS bu ON (blog.userid = bu.bloguserid)
    LEFT JOIN vb_user AS user ON (blog.userid = user.userid)
    WHERE
    state = 'visible' AND
    dateline <= 1248208213 AND
    blog.pending = 0 AND
    ~blog.options & AND
    bu.options_buddy & AND
    bu.options_member &
    ORDER BY dateline DESC
    LIMIT 1;

    MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS guestcanview
    FROM vb_blog AS blog
    LEFT JOIN vb_blog_user AS bu ON (blog.u' at line 4 Error Number : 1064 Request Date : Tuesday, July 21st 2009 @ 10:30:13 PM
    Error Date : Tuesday, July 21st 2009 @ 10:30:13 PM
    Script : http://www.cureconnections.com/cron.php?rand=1248208212
    Referrer : http://www.cureconnections.com/newthread.php?do=postthread&f=10
    IP Address : xxx.xxx.xxx.xx
    Username : Unregistered
    Classname : vb_database
    MySQL Version :
    Can anybody help me and give me a hint how to solve that issue? I switched off vBSEO to see if this was the reason but it wasn't, still the same.

    Thanks a lot!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X