Latest Announcemnent
New thread

vBulletin MySQL database error

Status
Not open for further replies.
W

Webmin

Active Member
70
2011
0
0
Need help Inferno Shoutbox vBulletin MySQL database error

Hello. I recently upgraded my forum from vBulletin 4.1.8 to vBulletin 4.1.9.
My inferno shoutbox plugin here: http://www.vbteam.info/4-x-x-how-to...v2-5-2-vb4-how-to-fix-works-with-4-0-7-a.html

It works fine when I install it on my fresh vBulletin 4.1.9 test site but when I install it on my main upgraded site it gives me a MySQL database error. Here is the MySQL database error:


Database error in vBulletin 4.1.9:

Invalid SQL:
select * from infernoshoutusers where s_user='1';

MySQL Error : Table '(mysite_databnamehere).infernoshoutusers' doesn't exist
Error Number : 1146
Request Date : Wednesday, December 21st 2011 @ 07:03:24 AM
Error Date : Wednesday, December 21st 2011 @ 07:03:24 AM
Script: http://(mydomainhere).com/index.php
Referrer :
Classname : vB_Database
MySQL Version : 5.5.14

I know there is a SQL table missing, but what can I do to fix this issue?

Thanks
 
9 comments
Hello. I recently upgraded my forum from vBulletin 4.1.8 to vBulletin 4.1.9.
My inferno shoutbox plugin here: http://www.vbteam.info/4-x-x-how-to/...h-4-0-7-a.html

It works fine when I install it on my fresh vBulletin 4.1.9 test site but when I install it on my main upgraded site it gives me a MySQL database error. Here is the MySQL database error:


Database error in vBulletin 4.1.9:

Invalid SQL:
select * from infernoshoutusers where s_user='1';

MySQL Error : Table '(mysite_databnamehere).infernoshoutusers' doesn't exist
Error Number : 1146
Request Date : Wednesday, December 21st 2011 @ 07:03:24 AM
Error Date : Wednesday, December 21st 2011 @ 07:03:24 AM
Script: http://(mydomainhere).com/index.php
Referrer :
Classname : vB_Database
MySQL Version : 5.5.14

I know there is a SQL table missing, but what can I do to fix this issue?

Thank
 
Did you try unistalling the shoutbox then installing it again so it can create the table?
make sure it works with your version.



"I know there is a SQL table missing, but what can I do to fix this issue?"

What can you do to fix the issue? read what you wrote again!
"I know there is a SQL table missing"
 
I tried uninstalling and re-installing it.

Also Sky says put that code to disable all plug-ins after <?php
Should I put the code in, then re-install the plugin then remove the code after I have installed the plugin?
 
after you put that code then all plugin will be disable
then u remove plugin make error >>> infernoshoutbox

after do reinstalled / upgrade the vbulletin, if success then you can enable the plugin again with disbale the code
//define('DISABLE_HOOKS', true); at at first // << to nonactive the code

next you can try to reinstalled the shoutbox
 
Webmin said:
I tried uninstalling and re-installing it.
Click to expand...

What about your MySQL version 5.5.14. I think thats the one to blame. Oracle did break backwards compatibility with some scripts (probably the one you are using as well).

You should try installing vBulletin 4.1.9 and the modification infernoshout in localhost, then export infernoshout tables and restore those in server.
 
PHP: 5.3.3
MySQL version: 5.5.14
NewEraCracker said above some scripts do not work with this version. What version should I downgrade too get it working?
 
Status
Not open for further replies.
Back
Top