Coinbase

Author Topic: SQL Query not installing?  (Read 2329 times)

0 Members and 1 Guest are viewing this topic.

Offline vitalik82

  • Newbie
  • *
  • Posts: 2
SQL Query not installing?
« on: May 03, 2009, 12:04:53 am »
Hello! I am running 2.0 RC1.

I try to install the mod manually. And it is ok until I get to the

Code
install.php
This file should not be able to execute standalone. You may have to run the following queries manually.

And 2 Queries:

Code: [Select]
CREATE TABLE IF NOT EXISTS {db_prefix}ads (
ADS_ID mediumint(8) unsigned NOT NULL auto_increment,
NAME tinytext NOT NULL,
CONTENT text NOT NULL,
BOARDS tinytext,
POSTS tinytext,
HITS mediumint(8) NOT NULL default '0',
TYPE smallint(4) NOT NULL default '0',
show_index smallint(4) NOT NULL default '0',
show_board smallint(4) NOT NULL default '0',
show_threadindex smallint(4) NOT NULL default '0',
show_lastpost smallint(4) NOT NULL default '0',
show_thread smallint(4) NOT NULL default '0',
show_bottom smallint(4) NOT NULL default '0',
show_welcome smallint(4) NOT NULL default '0',
show_topofpage smallint(4) NOT NULL default '0',
show_towerright smallint(4) NOT NULL default '0',
show_towerleft smallint(4) NOT NULL default '0',
show_betweencategories smallint(4) NOT NULL default '0',
show_underchildren smallint(4) NOT NULL default '0

INSERT IGNORE INTO {db_prefix}settings
(variable, value)
VALUES ('ads_displayAdsAdmin', '0'),
('ads_updateReports', '0'),
('ads_quickDisable', '0'),
('ads_lookLikePosts


I understood it so that I need to make a table in the DB. But when I copy the Queries to phpMyAdmin it returns me an error.

Offline ccbtimewiz

  • Sr. Member
  • ****
  • Posts: 326
    • Dream Portal
Re: SQL Query not installing?
« Reply #1 on: May 03, 2009, 08:01:39 pm »
Are you replacing {db_prefix} with your db_prefix?

Offline vitalik82

  • Newbie
  • *
  • Posts: 2
Re: SQL Query not installing?
« Reply #2 on: May 04, 2009, 02:31:06 am »
Are you replacing {db_prefix} with your db_prefix?

Yes:

Code: [Select]
ERROR: Незакрытая кавычка @ 832
STR: '
SQL: CREATE TABLE IF NOT EXISTS  smf_ads (
ADS_ID mediumint(8) unsigned NOT NULL auto_increment,
NAME tinytext NOT NULL,
CONTENT text NOT NULL,
BOARDS tinytext,
POSTS tinytext,
HITS mediumint(8) NOT NULL default '0',
TYPE smallint(4) NOT NULL default '0',
show_index smallint(4) NOT NULL default '0',
show_board smallint(4) NOT NULL default '0',
show_threadindex smallint(4) NOT NULL default '0',
show_lastpost smallint(4) NOT NULL default '0',
show_thread smallint(4) NOT NULL default '0',
show_bottom smallint(4) NOT NULL default '0',
show_welcome smallint(4) NOT NULL default '0',
show_topofpage smallint(4) NOT NULL default '0',
show_towerright smallint(4) NOT NULL default '0',
show_towerleft smallint(4) NOT NULL default '0',
show_betweencategories smallint(4) NOT NULL default '0',
show_underchildren smallint(4) NOT NULL default '0

SQL-запрос : 

CREATE TABLE IF NOT EXISTS smf_ads ( ADS_ID mediumint(8) unsigned NOT NULL auto_increment, NAME tinytext NOT NULL, CONTENT text NOT NULL, BOARDS tinytext, POSTS tinytext, HITS mediumint(8) NOT NULL default '0', TYPE smallint(4) NOT NULL default '0', show_index smallint(4) NOT NULL default '0', show_board smallint(4) NOT NULL default '0', show_threadindex smallint(4) NOT NULL default '0', show_lastpost smallint(4) NOT NULL default '0', show_thread smallint(4) NOT NULL default '0', show_bottom smallint(4) NOT NULL default '0', show_welcome smallint(4) NOT NULL default '0', show_topofpage smallint(4) NOT NULL default '0', show_towerright smallint(4) NOT NULL default '0', show_towerleft smallint(4) NOT NULL default '0', show_betweencategories smallint(4) NOT NULL default '0', show_underchildren smallint(4) NOT NULL default '0

Ответ MySQL:
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 ''0' at line 20

SMF Ads Support Forum

Re: SQL Query not installing?
« Reply #2 on: May 04, 2009, 02:31:06 am »
.

 

.