vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Affiliate hack prob ... Running a SQL query (https://vborg.vbsupport.ru/showthread.php?t=74598)

boo.3 01-18-2005 04:28 PM
Affiliate hack prob ... Running a SQL query
 
ok it says

Code:
Run this query:
DROP TABLE IF EXISTS affiliates;
CREATE TABLE affiliates (
        affiliate_id int(10) NOT NULL auto_increment,
        sitename varchar(50) NOT NULL,
        siteurl varchar(250) NOT NULL,
        sitedesc mediumtext NOT NULL,
        buttonurl varchar(150) NOT NULL,
        type tinyint(4) NOT NULL,
        email varchar(250) NOT NULL,
        clicksout int(20) NOT NULL,
        clicksin int(20) NOT NULL,
        active tinyint(4) NOT NULL,
        totalrating bigint(20) NOT NULL,
        totalvotes bigint(20) NOT NULL,
        approved tinyint(4) NOT NULL,
        PRIMARY KEY (affiliate_id),
        KEY sitename (sitename),
        KEY siteurl (siteurl),
        KEY email (email)
);
i do and i get this error


Code:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL a

i have no idea what i did wrong? i did everything right but the SQL queries :(


thanks in advanced

Marco van Herwaarden 01-18-2005 04:39 PM
How are you trying to run them?

If you're running them from ACP, try to execute one query at a time (1st the first line, second query line 2 and down)

boo.3 01-19-2005 12:31 AM
ahh ok i'll try it


All times are GMT. The time now is 06:14 AM.

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.01068 seconds
  • Memory Usage 1,710KB
  • 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
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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