Database error after installation

[Artur]

I completed the installation successfuly, no errors encountered but when I try to run cmps_index.php file I get this error:

Database error in vBulletin 3.5.3:
Invalid SQL:
UPDATE vbsession SET newposts = '0' WHERE userid = '1';
MySQL Error : Unknown column 'newposts' in 'field list'
Error Number : 1054

I searched the forum for clues but it seems I'm the only one with this specific problem.

[alxndr]

Same Problem here... :\

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE vbb_session SET newposts = '0' WHERE userid = '1';

MySQL Error : Unknown column 'newposts' in 'field list'
Error Number : 1054
Date : Wednesday, January 25th 2006 @ 08:47:13 PM

[Our Sponsors]

[alxndr]

I figured out the problem...
This extension basically dies when you use table name prefix in the vbb databbase (Cry)

[faz]

I am getting this error

Fatal error: Call to undefined function: build_datastore() in /home/ismailie/public_html/forums/admincp/vbacmps_install.php on line 249


Advice please

[Our Sponsors]

[Artur]

I figured out the problem...
This extension basically dies when you use table name prefix in the vbb databbase (Cry)

Alxndr, what did you do to correct the issue?

[alxndr]

Alxndr, what did you do to correct the issue?
You can try to create another colum in table session called 'newposts' (int length10) .
But I figure out there is another problem when you post the update query does not have the table prifixes.

I was too tired to look through the code so I tried to reinstall it. Then I got another problem...
Fatal error: Call to undefined function: build_datastore() in /backup/changp/public_html/ne/admincp/vbacmps_install.php on line 249

[faz]

Can anyone help ??

Fatal error: Call to undefined function: build_datastore() in /home/ismailie/public_html/forums/admincp/vbacmps_install.php on line 249

[gothic1213]

Can anyone help ??

Fatal error: Call to undefined function: build_datastore() in /home/ismailie/public_html/forums/admincp/vbacmps_install.php on line 249
This error is now spread accross about three threads. Does complicate life, eh?

[Brian]

For those getting the database error in the fist post: If you only received the error while you were upgrading and are able to make new posts without a problem then it's nothing to worry about. A new column is added to the session table during part of the install/upgrade and chances are that someone visisted the page while the new files were uploaded, but before the upgrade script had been run. Those who use table prefixes may still be getting those errors. If you are, please download the package from here again and upload the includes/vba_cmps_plugin_newpost.php file over your existing one.

For those getting the build_datastore() error:
Admin CP => vBulletin Options => Plugin/Hook System => Enable Plugin/Hook System

Make sure that option is turned on.

[faz]

Tried to reinstall it Same ERROR
Fatal error: Call to undefined function: build_datastore() in /home/ismailie/public_html/forums/admincp/vbacmps_install.php on line 249

It seems I have to Reinstall EVERYTHING ??
Forum & CMS again ?

Advice

[kmonty1978]

I still receive the same error after I overwrite the includes/vba_cmps_plugin_newpost.php file. But I am happy that I am not the only one, and people are looking into it.

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE vb3_session SET newposts = '0' WHERE userid = '1';

MySQL Error : Unknown column 'newposts' in 'field list'
Error Number : 1054
Date : Thursday, January 26th 2006 @ 04:02:32 PM
Script : http://blah.blah.com/index5.php
Referrer :
IP Address : 192.168.0.1
Username : Username
Classname : vb_database

[Brian]

faz - Please read the thread.

kmonty1978 - Did you run the upgrade script?

[lifepower]

Unfortunally, I'm having the same problem. I have uninstalled vbAdvanced and installed it again with the latest files and still am having this error:


Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE vb_session SET newposts = '0' WHERE userid = '1';

MySQL Error : Unknown column 'newposts' in 'field list'
Error Number : 1054
Date : Thursday, January 26th 2006 @ 03:23:48 PM

I do use prefix in tables though, which is "vb_".
Brian, is there any way to fix this?

[kmonty1978]

No this was on a new install, not a upgrade. I have even tried uninstall then reinstall, and then replaceing vba_cmps_plugin_newpost.php after the uninstall and installing. Same database error each time 1051 newposts.

I must also mention, this was not done on a new install of VB 3.5.3. This was done to one of my sites that is active with users, and the forums are still functional after the install and showing the error.

[Brian]

lifepower - Please download the package from here again and replace your includes/vba_cmps_plugin_newpost.php with the one in there.

kmonty1978 - Please download the package from here again and upload the admincp/vbacmps_install.php file over your existing one. Then try un-installing and re-installing.

[lifepower]

lifepower - Please download the package from here again and replace your includes/vba_cmps_plugin_newpost.php with the one in there.

kmonty1978 - Please download the package from here again and upload the admincp/vbacmps_install.php file over your existing one. Then try un-installing and re-installing.
I downloaded new package but updating file "vba_cmps_plugin_newpost.php" didn't help. However, I re-installed the entire package (after uploading everything again) and it worked perfectly. Many thanks!! :)

[kmonty1978]

I did the same as lifepower, but I had to rename my index5.php back to cmps_index.php. After doing that it all worked great. Thanks for all the help!!

[faz]

faz - Please read the thread.

kmonty1978 - Did you run the upgrade script?


Brian its All done
thanks a lot for all your help

once again thank You :)