The Arcive of vBulletin Modifications Site. |
|
|
#1
|
|||
|
|||
|
i have check and there are 3 coloums and 3 values whats wrong here's the error
Code:
Database error in vBulletin 3.0.3:
Invalid SQL:
INSERT into vb3_sotw
(id,winner,week,url_image)
VALUES
('',
'asddsa'
'a'
'asdfsd')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Code:
if ($_POST['do'] == 'sqltable')
{
globalize($_POST, array(
'winner',
'week_no',
'url_image'
));
$DB_site->query("
INSERT into " . TABLE_PREFIX . "sotw
(winner,week_no,url_image)
VALUES
(
'" . addslashes("$winner") . "'
'" . addslashes("$week_no") . "'
'" . addslashes("$url_image") . "')
");
print_stop_message('completed_database_backup_successfully');
}
id,winner,week,url_image can any please help this is doing my head in!!! :disappointed: |
|
#2
|
||||
|
||||
|
You are missing comma's between your values.
|
![]() |
|
|
| X vBulletin 3.8.12 by vBS Debug Information | |
|---|---|
|
|
More Information |
|
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|