vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   PHP register error! (https://vborg.vbsupport.ru/showthread.php?t=37954)

pattox2k1 04-27-2002 08:57 PM

PHP register error!
 
hey peoples, someone got this error while trying to sign up, so can you please try and help? i recently installed the stars hack if it has something to do with this

if any1 could help please do!

Database error in vBulletin 2.2.5:

Invalid SQL: INSERT INTO user (userid,username,password,email,styleid,parentemai l,coppauser,homepage,icq,aim,yahoo,signature,admin email,showemail,invisible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotification,receivepm,emailo npm,options,birthday,maxposts,startofweek,ipaddres s,pmpopup,referrerid,nosessionhash,avatarid,starle vel,starimg) VALUES (NULL,'Marcaveli','Marc','marcaveli@freenet.de','1 7','','0','http://www.makavelishakur.de.vu','112050545','Don Marcaveli','','','1','1','0','Junior Member','1019943374','1','-1','1019943374','1019943374','2','0','0','1','0',' 15','1982-10-3','-1','2','213.168.111.45','1','0','1','1','star')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Saturday 27th of April 2002 10:36:14 PM
Script: http://www.thugnature.net/forums/forums/register.php
Referer: http://www.thugnature.net/forums/register.php


thanks!

Mark Hensler 04-28-2002 05:44 PM

did you add a hack?

The error means that the number of columns listed in the user table doesn't match the number of VALUES() supplied.

pattox2k1 04-29-2002 10:40 AM

yes, i added the stars hack.

im not sure how to fix the problem though, im a newbie to VB

Sparkz 04-29-2002 11:42 AM

Check the install instructions for the hack again, and make sure you followed them completely. You might have missed something. At least that's what it looks like.

Admin 04-29-2002 11:52 AM

We already solved it. :)

Sparkz 04-29-2002 11:54 AM

nm, then :P

khobar 05-31-2002 04:55 PM

I'm having the same problem and I would like to know how you guys fixed it ....
in my case, english letters and numbers are excepted for user's name for registration but Arabic letters are not. My Board is in Arabic and most of people who come to register are Arabic speekers and they would like to use arabic names.
Also, Arabic letters are excepted only and only if combined with english letters or numbers like "ÇáÎÈÑ2002" or "ÇáÎÈÑyes" or "ÇáÎÈÑ2002yes"
I have award hack installed ...

please help...

khobar 05-31-2002 05:18 PM

and here is the error message i get when i try to register a member from admin cp

Database error in vBulletin Control Panel 2.2.2: Invalid SQL: INSERT INTO user (userid,usergroupid,username,password,email,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,receivebulletin,showemail,invisi ble,usertitle,customtitle,joindate,cookieuser,days prune,lastvisit,lastactivity,lastpost,posts,timezo neoffset,emailnotification,receivepm,emailonpm,ipa ddress,pmpopup,options,birthday) VALUES (NULL,'2','??????','godfather','bandar@saudiadesig n.com','1','','0','http://www.','','','','','1','1','0','','0',1022865614,'1 ','-1',1022865614,1022865614,1022865614,'0','0','1','1 ','0','','0','15','birthday') mysql error: Column count doesn't match value count at row 1 mysql error number: 1136

khobar 06-06-2002 06:41 AM

please help ... :(

Logician 06-06-2002 07:41 AM

khobar, count the fields you want to insert a value and count the values you gave to your MYSQL, they dont match.

You either applied a hack wrong or if it's your query you formed it uncorrectly.

Try matching fields and values one by one like:
userid= NULL
usergroupid=2
...
...

You'll catch which value/field you missed..

khobar 06-07-2002 08:23 PM

thanks alot Logician for replying. I have to tell you that I'm so bad in MYSQL and I'm afraid if I touch anything I will miss it up.
in this reply, I included most of the tables that have to do with users from phpmyadmin. and if you can point for me what you were talking about. I hope you'll catch the error and makes it easy for me :)
======================
Database alkhobar_vb - table user running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
userid int(10) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
usergroupid smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
username varchar(50) No Change Drop Primary Index Unique Fulltext
password varchar(50) No Change Drop Primary Index Unique Fulltext
email varchar(50) No Change Drop Primary Index Unique Fulltext
styleid smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
parentemail varchar(50) No Change Drop Primary Index Unique Fulltext
coppauser smallint(6) No 0 Change Drop Primary Index Unique Fulltext
homepage varchar(100) No Change Drop Primary Index Unique Fulltext
icq varchar(20) No Change Drop Primary Index Unique Fulltext
aim varchar(20) No Change Drop Primary Index Unique Fulltext
yahoo varchar(20) No Change Drop Primary Index Unique Fulltext
signature mediumtext No Change Drop Primary Index Unique Fulltext
adminemail smallint(6) No 0 Change Drop Primary Index Unique Fulltext
showemail smallint(6) No 0 Change Drop Primary Index Unique Fulltext
invisible smallint(6) No 0 Change Drop Primary Index Unique Fulltext
usertitle varchar(250) No Change Drop Primary Index Unique Fulltext
customtitle smallint(6) No 0 Change Drop Primary Index Unique Fulltext
joindate int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
cookieuser smallint(6) No 0 Change Drop Primary Index Unique Fulltext
daysprune smallint(6) No 0 Change Drop Primary Index Unique Fulltext
lastvisit int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
lastactivity int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
lastpost int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
posts smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
timezoneoffset varchar(4) No Change Drop Primary Index Unique Fulltext
emailnotification smallint(6) No 0 Change Drop Primary Index Unique Fulltext
buddylist mediumtext No Change Drop Primary Index Unique Fulltext
ignorelist mediumtext No Change Drop Primary Index Unique Fulltext
pmfolders mediumtext No Change Drop Primary Index Unique Fulltext
receivepm smallint(6) No 0 Change Drop Primary Index Unique Fulltext
emailonpm smallint(6) No 0 Change Drop Primary Index Unique Fulltext
pmpopup smallint(6) No 0 Change Drop Primary Index Unique Fulltext
avatarid smallint(6) No 0 Change Drop Primary Index Unique Fulltext
options smallint(6) No 15 Change Drop Primary Index Unique Fulltext
birthday date No 0000-00-00 Change Drop Primary Index Unique Fulltext
maxposts smallint(6) No -1 Change Drop Primary Index Unique Fulltext
startofweek smallint(6) No 1 Change Drop Primary Index Unique Fulltext
ipaddress varchar(20) No Change Drop Primary Index Unique Fulltext
referrerid int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
nosessionhash smallint(6) No 0 Change Drop Primary Index Unique Fulltext
inforum smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
receivebulletin smallint(5) UNSIGNED No 1 Change Drop Primary Index Unique Fulltext
award tinytext No Change Drop Primary Index Unique Fulltext
========================
Database alkhobar_vb - table useractivation running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
useractivationid int(10) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
userid int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
dateline int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
activationid char(20) No Change Drop Primary Index Unique Fulltext
type smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
==========================
Database alkhobar_vb - table useraward running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
id smallint(5) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
awardsid smallint(5) No 0 Change Drop Primary Index Unique Fulltext
userid smallint(5) No 0 Change Drop Primary Index Unique Fulltext
name varchar(60) No Change Drop Primary Index Unique Fulltext
url varchar(100) No Change Drop Primary Index Unique Fulltext
aw smallint(4) No 0 Change Drop Primary Index Unique Fulltext
===========================
Database alkhobar_vb - table userfield running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
userid int(10) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
field1 char(250) No Change Drop Primary Index Unique Fulltext
field2 char(250) No Change Drop Primary Index Unique Fulltext
field3 char(250) No Change Drop Primary Index Unique Fulltext
field4 char(250) No Change Drop Primary Index Unique Fulltext
field5 char(250) No Change Drop Primary Index Unique Fulltext
===========================
Database alkhobar_vb - table usergroup running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
usergroupid smallint(5) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
title char(100) No Change Drop Primary Index Unique Fulltext
usertitle char(100) No Change Drop Primary Index Unique Fulltext
cancontrolpanel smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canmodifyprofile smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canviewmembers smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canview smallint(6) No 0 Change Drop Primary Index Unique Fulltext
cansearch smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canemail smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canpostnew smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canmove smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canopenclose smallint(6) No 0 Change Drop Primary Index Unique Fulltext
candeletethread smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canreplyown smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canreplyothers smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canviewothers smallint(6) No 0 Change Drop Primary Index Unique Fulltext
caneditpost smallint(6) No 0 Change Drop Primary Index Unique Fulltext
candeletepost smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canusepm smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canpostpoll smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canvote smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canpostattachment smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canpublicevent smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canpublicedit smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canthreadrate smallint(6) No 1 Change Drop Primary Index Unique Fulltext
maxbuddypm smallint(6) UNSIGNED No 5 Change Drop Primary Index Unique Fulltext
maxforwardpm smallint(6) UNSIGNED No 5 Change Drop Primary Index Unique Fulltext
cantrackpm smallint(6) No 1 Change Drop Primary Index Unique Fulltext
candenypmreceipts smallint(6) No 1 Change Drop Primary Index Unique Fulltext
ismoderator smallint(6) No 0 Change Drop Primary Index Unique Fulltext
canwhosonline smallint(6) No 1 Change Drop Primary Index Unique Fulltext
canwhosonlineip smallint(6) No 0 Change Drop Primary Index Unique Fulltext
showgroup smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
cangetattachment smallint(6) No 1 Change Drop Primary Index Unique Fulltext
==============================
Database alkhobar_vb - table usertitle running on localhost
[ Browse ] [ Select ] [ Insert ] [ Empty ] [ Drop ]

Field Type Attributes Null Default Extra Action
usertitleid smallint(5) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
minposts smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
title char(250) No Change Drop Primary Index Unique Fulltext
==============================

I know this looks funny but it's more safe for me this way .

best regards

Logician 06-07-2002 09:11 PM

Look at your query:

INSERT INTO user (userid,usergroupid,........) VALUES (NULL,'2',....)

With this query you command MYSQL to insert to user table:
for userid field VALUE null,
for usergroupid field VALUE 2
etc.
etc.

Now count the fields between the first ()s. (They are your fields) and then count the values between second ()s, (They are your values to insert into these fields), they simply dont match. You either miss a field name or value.

If you are applying a hack, this query is wrong so it means that you didnt apply it correctly. If you formed the query by yourself it either means you added a field to an existing query but you didnt add its value OR you added a value without mentioning its field.

You have to check them one by one and see which value or field is missing or extra. Your table structure has nothing to do with this error.


All times are GMT. The time now is 05:02 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01318 seconds
  • Memory Usage 1,785KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (12)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete