This section is an archive with no posting allowed. The software represented in this forum is no longer supported or updated. If you need help upgrading to a newer version of vBulletin please open a support ticket. You can also post in the section supporting the upgrade version you're planning to use.
We are sorry for any inconvenience this may cause.
Welcome to the vBulletin support forums! In our community forums you can receive professional support and assistance with any issues you might have with your vBulletin Products.
I've recently re-activated my account with a web host, and they were kind enough to dump an existing SQL file of a previous forum for me. However, this is what they e-mailed to me:
I have restored the dump into a database named "maddux_forum". You will need to modify your forums database configuration to use this database, and you will need to create a new database user and grant it access to this database through the cPanel MySQL Manager.
Now, I've created the user name, but I don't know what to do next in order to bring my forum back up (it's still down). Do I reinstall the vBulletin 3.6 software or what? How exactly do I follow the instructions mentioned above in bold?
Just did that, and the forum still won't load. Do I have to run the vB 3.6 installation in order for this to work? Thus far, all I've done is upload the vB files to the server after the SQL dump was successful.
But yeah, I've edited the config.php file like you said and nothing.
Database error
The database has encountered a problem.
Please try the following:
* Load the page again by clicking the Refresh button in your web browser.
* Open the www.xxxx.com home page, then try to open another page.
* Click the Back button to try another link.
The www.xxxxx.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
and as for the error specifically...
Database error in vBulletin : mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'root'@'localhost' (using password: NO) /home/xxxx/public_html/forum/includes/class_core.php on line 271
Warning: Unknown(/home/xxx/public_html/forum/includes/synergy.php): failed to open stream: No such file or directory in /includes/init.php(317) : eval()'d code on line 5
Fatal error: (null)() [function.require]: Failed opening required '/home/xxx/public_html/forum/includes/synergy.php' (include_path='/usr/lib/php:.:/usr/php4/lib/php:/usr/local/php4/lib/php') in /home/xxx/public_html/forum/includes/init.php(317) : eval()'d code on line 5
Just did so. Reuploaded fresh vB files, and now I get this:
Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
infractiongroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1214854697
ORDER BY username ASC;
MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Error Number : 1054
Date : Monday, June 30th 2008 @ 03:53:17 PM
Script : http://www.xxx.com/forum/
Referrer :
IP Address : xxxxx
Username : Unregistered
Classname : vb_database
I feel like an idiot, Steve. I apologize for inconveniencing you. The old vb database was actually running 3.5.4, when I thought it was running 3.6, which is why I uploaded 3.6 files.
Well, I removed all the 3.6 files and replaced them with those of 3.5.4 (still did not run the installation script). However, I'm now getting this error:
Invalid SQL:
SELECT cron.*
FROM cron AS cron
LEFT JOIN product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1214856315 AND cron.active = 1
AND (product.productid IS NULL OR product.active = 1)
ORDER BY cron.nextrun
LIMIT 1;
MySQL Error : Unknown column 'cron.active' in 'where clause'
Error Number : 1054
Date : Monday, June 30th 2008 @ 04:05:15 PM
Script : http://www.xxxx.com/forum/cron.php?rand=506450
Referrer :
IP Address : xxxxxxxx
Username : Unregistered
Classname : vb_database
PS: I know you're now obligated to move this thread to the vb 3.5 section, but I could still very much use your assistance....
How am I supposed to upgrade (which is what I want to do) when the database I need to restore is 3.5.4? I'll need 3.5.4 files in order to bring it back, and then upgrade to 3.7.2, but first I need 3.5.4 assistance....
How am I supposed to do anything at this point without 3.5 support?
My webhost, upon my request, restored a vBulletin 3.5.4. dump into a database. I did a back-up of the forum last year. He sent this:
I have restored the dump into a database named "maddux_forum". You will need to modify your forums database configuration to use this database, and you will need to create a new database user and grant it access to this database through the cPanel MySQL Manager.
The part in bold is what I'm trying to do. I'm trying to restore and activate the old forum (3.5.4). I've re-uploaded 3.5.4 files because the original files were not saved, just the database.
But I've run into issues. My latest one being this:
Invalid SQL:
SELECT cron.*
FROM cron AS cron
LEFT JOIN product AS product ON (cron.product = product.productid)
WHERE cron.nextrun <= 1214856315 AND cron.active = 1
AND (product.productid IS NULL OR product.active = 1)
ORDER BY cron.nextrun
LIMIT 1;
MySQL Error : Unknown column 'cron.active' in 'where clause'
Error Number : 1054
Date : Monday, June 30th 2008 @ 04:05:15 PM
Script : http://www.xxxx.com/forum/cron.php?rand=506450
Referrer :
IP Address : xxxxxxxx
Username : Unregistered
Classname : vb_database
To summarize, this is what I've done:
1.) Restored the dump (vB forum 3.5.4)
2.) Uploaded 3.5.4 files (did not run the installation file)
3.) edited config.php to point to the database name (maddux_forum)
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also consent to the transfer of your data to our servers in the United States, where data protection laws may be different from those in your country.
Comment