Column count doesn’t match value count at row 1

Hi There,

From what I have read the ‘Column count doesn’t match value count at row 1’ error is common and easy to troubleshoot? Yet I cannot find my issue!!

I have take files which were created years ago and started to modify them to my needs, now i’m sure I have probably just deleted or added something in the incorrect place.

There are many files that create this plugin but from what I have read it’s the MySQL Queries that cause this error, so below I have quoted queries from all the files!

Hope someone can help!!

File 1

[code]Line 141: $mysql_query = “REPLACE INTO $mysql_table (id,gamename,gametype,league,tag1,tag2,team1,team2,ground,sides,scores1,scores2,result,players1,players2,contact,website,rules,info,screenshots,demos,calendar,timestamp) VALUES (‘$form[id]’,’$form[gamename]’,’$form[gametype]’,’$form[league]’,’$form[tag1]’,’$form[tag2]’,’$form[team1]’,’$form[team2]’,’$form[ground]’,’$form[sides]’,’$form[scores1]’,’$form[scores2]’,’$form[result]’,’$form[players1]’,’$form[players2]’,’$form[contact]’,’$form[website]’,’$form[rules]’,’$form[info]’,’$form[screenshots]’,’$form[demos]’,’$form[calendar]’,’$form[timestamp]’)”;[/code]

File 2

[code]Line 205: $mysql_query = “REPLACE INTO “.MPREFIX.”$cal_event (event_id,event_title) VALUES (”,’PLACE HOLDER’)”;[/code]

[code]Line 212: $mysql_query = “REPLACE INTO $mysql_table (id,gamename,gametype,league,tag1,tag2,team1,team2,ground,sides,scores1,scores2,result,players1,players2,contact,website,rules,info,screenshots,demos,calendar,timestamp) VALUES (‘$form[id]’,’$form[gamename]’,’$form[gametype]’,’$form[league]’,’$form[tag1]’,’$form[tag2]’,’$form[team1]’,’$form[team2]’,’$form[ground]’,’$form[sides]’,’$form[scores1]’,’$form[scores2]’,’$form[result]’,’$form[players1]’,’$form[players2]’,’$form[contact]’,’$form[website]’,’$form[rules]’,’$form[info]’,’$form[screenshots]’,’$form[demos]’,’$form[calendar]’,’$form[timestamp]’)”;[/code]

[code]Line 248: $mysql_query = “REPLACE INTO “.MPREFIX.”$cal_event (event_id,event_start,event_end,event_datestamp,event_title,event_location,event_details,event_author,event_category) VALUES (‘$form[calendar]’,’$form[timestamp]’,’$form[timestamp]’,’$rwar_id’,’$calendar_title’,’$calendar_subject’,’1.RWar’,’$rwar_calendar_category’)”;[/code]

[code]Line 335: $mysql_query = “SELECT * FROM $mysql_table WHERE id = ‘$_GET[id]’ LIMIT 1”;[/code]

File 3

[code]Line 107: $mysql_query = “REPLACE INTO $mysql_table (id,gamename,gametype,league,tag1,tag2,team1,team2,ground,sides,scores1,scores2,result,players1,players2,contact,website,rules,info,screenshots,demos,calendar,timestamp) VALUES (‘$mysql_row[id]’,’$mysql_row[gamename]’,’$mysql_row[gametype]’,’$mysql_row[league]’,’$mysql_row[tag1]’,’$mysql_row[tag2]’,’$mysql_row[team1]’,’$mysql_row[team2]’,’$mysql_row[ground]’,’$mysql_row[sides]’,’$mysql_row[scores1]’,’$mysql_row[scores2]’,’$mysql_row[result]’,’$mysql_row[players1]’,’$mysql_row[players2]’,’$mysql_row[contact]’,’$mysql_row[website]’,’$mysql_row[rules]’,’$mysql_row[info]’,’$mysql_row[screenshots]’,’$mysql_row[demos]’,’$mysql_row[calendar]’,’$mysql_row[timestamp]’)”;[/code]

File 4

[code]Line 86: $mysql_query = “REPLACE INTO $mysql_table (id,gamename,gametype,league,tag1,tag2,team1,team2,ground,sides,scores1,scores2,result,players1,players2,contact,website,rules,info,screenshots,demos,calendar,timestamp) VALUES (‘$mysql_row[id]’,’$mysql_row[gamename]’,’$mysql_row[gametype]’,’$mysql_row[league]’,’$mysql_row[tag1]’,’$mysql_row[tag2]’,’$mysql_row[team1]’,’$mysql_row[team2]’,’$mysql_row[ground]’,’$mysql_row[sides]’,’$mysql_row[scores1]’,’$mysql_row[scores2]’,’$mysql_row[result]’,’$mysql_row[players1]’,’$mysql_row[players2]’,’$mysql_row[contact]’,’$mysql_row[website]’,’$mysql_row[rules]’,’$mysql_row[info]’,’$mysql_row[screenshots]’,’$mysql_row[demos]’,’$mysql_row[calendar]’,’$mysql_row[timestamp]’)”;[/code]

If it helps further I can also post all of the original queries before I modified any of it!

Also in #PHP _↴