Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 06 Jul 2007, 21:11
Fungsten's Avatar
Fungsten Fungsten is offline
 
Join Date: Jul 2006
On my test board whenever I click update for a user I get this error message.

Database error in vBulletin 3.6.7:
Invalid SQL:
UPDATE userfield SET
field1 = '',
field2 = '',
field6 = '',
field3 = '',
field4 = '',
field7 = '',
field8 = ''
WHERE userid = 21;
MySQL Error : Unknown column 'field6' in 'field list'
Error Number : 1054
Date : Friday, July 6th 2007 @ 01:01:35 PM
Script : http://www.Blah blah/testvb/forum/ad....php?do=update
Referrer : http://www.blahsblaok/testvb/forum/a...p?do=edit&u=21
IP Address : XXX.XX.XXX.XXX
Username : Username
Classname : vb_database
I have attempted to delete field6 but I get another message.

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_cprofilefield = 'a:8:{s:11:\"field1_desc\";s:28:\"A few details about yourself\";s:12:\"field1_title\";s:9:\"Biography\";s:11:\"field2_desc\";s:14:\"W here 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\";}', 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_adv_portal = 'a:30:{s:12:\"active_users\";s:12:\"Active Users\";s:7:\"buddies\";s:7:\"buddies\";s:2:\"by\";s:2:\"By\";s:17:\"discuss_thi s_poll\";s:17:\"Discuss This Poll\";s:14:\"edit_this_post\";s:14:\"Edit This Post\";s:12:\"last_post_by\";s:12:\"Last post by\";s:19:\"latest_forum_topics\";s:19:\"Latest Forum Topics\";s:7:\"new_pms\";s:7:\"New PMs\";s:11:\"no_x_online\";s:45:\"<span class=\"smallfont\">No %1$s online</span>\";s:15:\"no_x_to_display\";s:19:\"No %1$s to Display.\";s:29:\"not_a_member_yet_register_now\";s:69:\"Not a member yet?<br />\n<a href=\"%1$s/register.php\">Register Now!</a>\";s:14:\"online_buddies\";s:14:\"Online Buddies\";s:2:\"pm\";s:2:\"PM\";s:12:\"poll_results\";s:12:\"Poll Resu

I'd put the rest of the message in but it's too long this forum. I'll add another post.

Here's the end of it.

Error Number : 1054
Date : Friday, July 6th 2007 @ 01:05:50 PM
Script : http://www.jjlkijjlkj;j/testvb/forum...ld.php?do=kill
Referrer : http://www.blah /testvb/forum/adminc...ofilefieldid=6
IP Address : XXX.XXX.XXX.XXX
Username : Admin
Classname : vb_database

Last edited by Fungsten; 06 Jul 2007 at 21:14. Reason: Automerged Doublepost
Reply With Quote
  #2  
Old 06 Jul 2007, 21:53
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
The message is telling what the issue is, check field6
Reply With Quote
  #3  
Old 06 Jul 2007, 22:04
Fungsten's Avatar
Fungsten Fungsten is offline
 
Join Date: Jul 2006
Originally Posted by snakes1100 View Post
The message is telling what the issue is, check field6
When I try to delete it I get the error message as stated in the post.
Reply With Quote
  #4  
Old 06 Jul 2007, 22:17
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
MySQL Error : Unknown column 'field6' in 'field list'

The msg states unknown, i would assume its missing.
Reply With Quote
  #5  
Old 06 Jul 2007, 22:23
Fungsten's Avatar
Fungsten Fungsten is offline
 
Join Date: Jul 2006
Originally Posted by snakes1100 View Post
MySQL Error : Unknown column 'field6' in 'field list'

The msg states unknown, i would assume its missing.
But it still shows up in the User Profile Field Manager.
Reply With Quote
  #6  
Old 07 Jul 2007, 08:21
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
Ok, run this SQL Query:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Then delete it.
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #7  
Old 07 Jul 2007, 20:25
Fungsten's Avatar
Fungsten Fungsten is offline
 
Join Date: Jul 2006
Originally Posted by Dismounted View Post
Ok, run this SQL Query:

SQL Query: (how to run queries)
ALTER TABLE `userfield`</p><p>ADD `field6` INT( 5 ) UNSIGNED NOT NULL DEFAULT 0

Then delete it.
Thanks Dismounted. It was already fixed though. I'll save your query if I need it!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 07:18.

Layout Options | Width: Wide Color: