Database Error Adding Questions

[chaselafon]

After I add a quesiton, I get a database error. The question works, but I can't put in answers, etc. The same happens when I try to edit them.

This is for registration verification.

Can anyone tell me what files might be causing this?

[Steve Machol]

We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

[chaselafon]

Steve, my Database Error is about 600,000 characters in a code box, and since no support is being offered, I can't post it here to to the character limit. :\

[Steve Machol]

Try just posting the last 10 lines or so of that error.

Also please explain what you are doing exactly.

[chaselafon]

Okay, Steve.

I'm in my ACP, and I am clicking "Human Verification Manager" under "vBulletin Options." I then click "Add New Question", which takes me to a question page. I've added in a question, and I do not add in a regular expression (I've tried all combinations). This then takes me to the Database Error Page.

The error is consisted of five lines, but one goes far out to the right.

Here is the first part:

Database error in vBulletin 3.7.0 Beta 2:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_cprofilefield = 'a:14:{s:12:\"field12_desc\";s:122:\"Enter your Myspace Friend ID or your MySpace URL.\r\n<br>\r\nExample: 8039320 or Myspace.com/Tom. You would just enter in Tom.\";s:13:\"field12_title\";s:17:\"MySpace Friend ID\";s:12:\"field13_desc\";s:158:\"Enter your FaceBook Friend ID. It\'s displayed on your profile page in your address bar.\r\n<br>\r\nExample: http://hs.facebook.com/profile.php?id=<b>123456789</b>\";s:13:\"field13_title\";s:16:\"Facebook User ID\";s:11:\"field1_desc\";s:28:\"A few details about yourself\";s:12:\"field1_title\";s:9:\"Biography\";s:11:\"field2_desc\";s:14:\"Where you live\";s:12:\"field2_title\";s:8:\"Location\";s:11:\"field3_desc\";s:17:\"Your hobbies, etc\";s:12:\"field3_title\";s:9:\"Interests\";s:11:\"field4_desc\";s:8:\"Your job\";s:12:\"field4_title\";s:10:\"Occupation\";s:11:\"field8_desc\";s:18:\"Select your gender\";s:12:\"field8_title\";s:6:\"Gender\";}', phrasegroup_reputationlevel = 'a:15:{s:11:\"reputation1\";s:30:\"is infamous around these parts\";s:12:\"reputation10\";s:29:\"is a glorious beacon of light\";s:12:\"reputation11\";s:22:\"is a name known to all\";s:12:\"reputation12\";s:27:\"is a splendid one to behold\";s:12:\"reputation13\";s:23:\"has much to be proud of\";s:12:\"reputation14\";s:22:\"has a brilliant future\";s:12:\"reputation15\";s:30:\"has a reputation beyond repute\";s:11:\"reputation2\";s:24:\"can only hope to improve\";s:11:\"reputation3\";s:44:\"has a little shameless behaviour in the past\";s:11:\"reputation4\";s:36:\"is an unknown quantity at this point\";s:11:\"reputation5\";s:26:\"is on a distinguished road\";s:11:\"reputation6\";s:30:\"will become famous soon enough\";s:11:\"reputation7\";s:28:\"has a spectacular aura about\";s:11:\"reputation8\";s:23:\"is a jewel in the rough\";s:11:\"reputation9\";s:19:\"is just really nice\";}', phrasegroup_infractionlevel = 'a:4:{s:22:\"infractionlevel1_title\";s:22:\"Spammed Advertisements\";s:22:\"infractionlevel2_title\";s:24:\"Insulted Other Member(s)\";s:22:\"infractionlevel3_title\";s:24:\"Signature Rule Violation\";s:Here is the last part:

MySQL Error : Unknown column 'phrasegroup_hvquestion' in 'field list'
Error Number : 1054
Date : Monday, December 17th 2007 @ 09:34:19 PM
Script : http://quahogbulletin.com/forum/admincp/verify.php?do=updatequestion
Referrer : http://quahogbulletin.com/forum/admincp/verify.php?do=modifyquestion
IP Address : EDITED OUT by ME
Username : Chase
Classname : vB_Database

[Steve Machol]

Try this. Reupload the 3.7.0 includes/*.xml files and run 'install'finalupgrade.php'. Check the upper right-hand corner of the upgrade page to make sure they are showing as version 3.7.0.

[Steve Machol]

Actually I just saw this. See post #2:

http://www.vbulletin.com/forum/showthread.php?p=1469629#post1469629

[chaselafon]

How do I run a query? When I click Execute SQL Queries it says I'm not authorized to do so.

[Steve Machol]

To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = 'x';

...with x being your userid number.

[chaselafon]

I think I'll wait for a fix to be issued, since this isn't causing any harm to my board. (right?)