vb.org Archive - View Single Post - can't login to my admincp with error #1064

index · #1 06-09-2005, 10: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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01140 seconds Memory Usage 1,807KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: