The Arcive of vBulletin Modifications Site.

index · #1 06-09-2005, 09:38 AM

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">&nbsp;</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 &gt; 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