vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   More.. and more errors... (https://vborg.vbsupport.ru/showthread.php?t=40966)

Mystislav 07-12-2002 11:04 AM
More.. and more errors...
 
Ok I've been on my vb installing hacks for a while. And I noticed a few things..

First of all, when I try to run my sql query I get this

Quote:
Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: CREATE TABLE user_rate (
userrateid int(10) unsigned NOT NULL auto_increment,
rateduser int(10) unsigned DEFAULT '0' NOT NULL,
userid int(10) unsigned DEFAULT '0' NOT NULL,
userrating smallint(6) DEFAULT '0' NOT NULL,
PRIMARY KEY (userrateid),
KEY rateduser (userid)
);
ALTER TABLE user ADD ratenum SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE user ADD ratetotal SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE user ADD allowrate SMALLINT(5) UNSIGNED DEFAULT '1' NOT NULL;
mysql error: You have an error in your SQL syntax near ';
ALTER TABLE user ADD ratenum SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL;
ALT' at line 8

mysql error number: 1064

Date: Friday 12th of July 2002 08:03:44 AM
Script: http://66.192.45.86/~sjmadho/board/b...dmin/query.php
Referer: http://www.sjmadhouse.net/board/admin/query.php
then when I try to ban people, it gives me a error and when I try to change ppls username it is a error.. what do I do?

scsa20 07-12-2002 01:27 PM
if you backed up your database before running that SQL query, then restore the back up copy...if not, try running the restore.php file (I think that's what it's called)...it's found in the extras folder.

Mystislav 07-12-2002 02:41 PM
Hmm, this ++++ is getting worse. Now when I click on a users name to look at their profile, it gives me a error.. theres tons of errors... check it urself http://sjmadhouse.net/board then go to general and click on a users name who started a thread... also my sql wont let me do ++++...what do I do? :(

Mystislav 07-12-2002 05:30 PM
Someone please help me, I'm getting errors everywhere, even when I try to change my avatar...


All times are GMT. The time now is 12:57 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00951 seconds
  • Memory Usage 1,717KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete