| AN-net |
08-17-2005 04:25 PM |
mysql syntax error>_>
ok well i am completely confused to why this happening
the error is
Code:
Database error in vBulletin 3.0.7:
Invalid SQL:
INSERT INTO journals
(journalist, journalist_id, journaldate,
journaldesc, private, allowbuddies, whocanview, lastentry,
lastentry_date, lastentry_misc, ipaddress, entrycount, active,privatecount
)
VALUES
('Antonbomb22', '20',
1124306286, '', 0, , '',
'testing private entry', 1124306286,'a:3:{s:7:\"private\";i:1;s:10:\"whocanview\";s:0:\"\";s:12:\"allowbuddies\";i:0;}', '69.141.184.51'
,1,1,1
)
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '',
'testing private entry', 1124306286,'a:3:{s:7:\"private\";i:1;s:10:' at line 8
mysql error number: 1064
this is the php code/query:
PHP Code:
$DB_site->query("
INSERT INTO ".TABLE_PREFIX."journals
(journalist, journalist_id, journaldate,
journaldesc, private, allowbuddies, whocanview, lastentry,
lastentry_date, lastentry_misc, ipaddress" . ($journal['usejournalname'] ? ', journalname' : '') . "" . ($setting['autoapprove_entries']==1 ? ', entrycount' : '') . "" . ($setting['autoapprove_journals']==1 ? ', active' : '') . "" . ($addto['privatecount'] ? ',privatecount': '') . "
)
VALUES
('" . addslashes($bbuserinfo['username']) . "', '" . intval($bbuserinfo['userid']) . "',
" . TIMENOW . ", '" . addslashes($journal['description']) . "', " . $journal['private'] . ", " . $journal['allowbuddies'] . ", '" . addslashes($journal['whocanview']) . "',
'" . addslashes($entry['title']) . "', " . TIMENOW . ",'". addslashes($lastentrymisc) ."', '" . IPADDRESS . "'
" . ($journal['usejournalname'] ? $nameformat : '') . "" . ($setting['autoapprove_entries']==1 ? ',1' : '') . "" . ($setting['autoapprove_journals'] ? ',1' : '') . "" . ($addto['privatecount'] ? ',1' : '') . "
)
");
also why is there a 1 after 'active' and a 11 at the end of values. those should not be there.
any help would be appreciated.
edit:
fixed my active and stuff problems but still getting syntax error>_> |
More Information