PDA

View Full Version : database error when posting


blacura
Tue 29th Sep '09, 8:17am
every time i either post or reply i get this error


Database error in vBulletin 3.8.3:

Invalid SQL:
INSERT INTO blog_text
(username, userid, bloguserid, title, pagetext, blogid, allowsmilie, state, dateline, ipaddress, ame_flag)
VALUES
('James', 93, 93, '', 'test comment', 3, 1, 'visible', 1254226405, '1182251609', 0);

MySQL Error : Unknown column 'ame_flag' in 'field list'
Error Number : 1054
Request Date : Tuesday, September 29th 2009 @ 06:13:25 AM
Error Date : Tuesday, September 29th 2009 @ 06:13:25 AM
Script : http://www.ladiesletsride.com/forum/blog_post.php?do=postcomment
Referrer : http://www.ladiesletsride.com/forum/blog.php?b=3
IP Address : 70.119.186.89
Username : James
Classname : vB_Database
MySQL Version : 5.0.81-community-log

PitchouneN64ngc
Tue 29th Sep '09, 11:57am
As far as I know, there is no 'ame_flag' column in blog.

You should check the mods you installed/removed from your forum to see which modification is causing your problem.

1QuickSI
Fri 2nd Oct '09, 3:02pm
http://www.vbulletin.org/forum/showthread.php?t=202476

blacura
Mon 12th Oct '09, 10:19pm
None of those fixes help. i still get a database error. anyone know a way around this error?

1QuickSI
Tue 13th Oct '09, 3:29am
First this is not a VB bug so we should not be posting or fixing things here. You should be posting over at .org under the modifications suport thread.

To fix I would uninstall and remove ALL files. I would then attempt to reinstall as it seems that a table field was not properly set up during the initial install.