vBulletin MySQL database error

[Webmin]

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?

Thanks

Webmin Reviewed by Webmin on 21st Dec 2011. 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/50809-4-x-x-inferno-vbshout-pro-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 Rating: 5

[Webmin]

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

[bxflow]

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"

[-sky-]

pur this at config.php to disable all plugin before

after
<?php
place this
define('DISABLE_HOOKS', true);

[Webmin]

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?

[-sky-]

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

[NewEraCracker]

I tried uninstalling and re-installing it.

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.

[WebCare360]

You should globally turn off the plugins or simply just disable the pluggin causing the problem i.e; infernoshout

[Webmin]

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?

[NewEraCracker]

PHP should be upgraded at least to version 5.3.6 (and then to 5.3.9 when it is released) and MySQL should be downgraded to version 5.1.60.