Hi All,
I got this error msg when I added a hack to my vb 3.0.7, the forum is working fine, but when I try to login to my admincp, it gives me a white page with this error msg don't know why:
PHP Code:
<html><head><title> Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
<body></table></td></tr></table></form>
<blockquote><p class="error"> </p><p class="error"><b>There seems to have been a slight problem with the database.</b><br />
Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="mailto:dbmaster@xxx">Technical Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p></blockquote>
<!--
Database error in Board 3.0.7:
Invalid SQL:
SELECT * FROM cpsession
WHERE userid =
AND hash = '6c51f8d10ea098719401fb448db4b5e3'
AND dateline > 1118169812
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 'AND hash = '6c51f8d10ea098719401fb448db4b5e3'
AND dateline
mysql error number: 1064
Date: Tuesday 07th of June 2005 10:43:32 PM
-->
</body></html>
The codes that I added to my vb db is this sql lines is this:
PHP Code:
receivebulletin SMALLINT (5) UNSIGNED DEFAULT '1' NOT NULL ;
ALTER TABLE " . TABLE_PREFIX . "user ADD receivebulletin_type SMALLINT (5) UNSIGNED DEFAULT '1' NOT NULL ;
#----------------------------
# Table structure for stamps
#----------------------------
CREATE TABLE `stamps` (
`stampid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(60) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
PRIMARY KEY (`stampid`)
) TYPE=MyISAM;
#----------------------------
# Records for table stamps
#----------------------------
insert into stamps values
(1, 'منقول', 'images/stamps/1.gif'),
(2, 'مميز', 'images/stamps/2.gif'),
(3, 'مكرر', 'images/stamps/3.gif');
#----------------------------
# ALTER TABLE thread
#----------------------------
ALTER TABLE `thread` ADD `stampid` SMALLINT( 5 ) DEFAULT '0' NOT NULL ;
I hope I can get a solution in how to solve this problem out, can anyone help me ??
waiting a reply
Thanks a lot
index
06-09-2005, 10:38 AM
can't login to my admincp with error #1064
Linear Mode
