|
A mysql bug in the nightly build...
|
|
By Phantros , Section Help! []
Posted on Sat May 11, 2002 at 12:00:00 PM PST
|
 |
|
After an embarrassingly long time of trying to install the nightly build of scoop (I'd rather not say just how long ;), something occurred to me: This time, it might not be just my newbieness at fault.
|
| When trying to install the nightly build, I got a SQL syntax error. (see below) I'm a bit of a newbie to linux/mysql/scoop so at first I thought it was my fault. After eventually trying the stable .8 version and succeeding without problem, I'm now guessing that's not the case.
Lesson learned: Use the stable version before playing with the development one.
Error:
DBD::mysql::db do failed: You have an error in your SQL syntax near '---------------------------------------------------------
-- Server version 4.0.' at line 4 at ./install.pl line 572, <DBF> line 42.
Error running [-- MySQL dump 8.19
--
-- Host: localhost Database: scoop
---------------------------------------------------------
-- Server version 4.0.1-alpha
--
-- Table structure for table 'ad_info'
--
CREATE TABLE ad_info (
ad_id int(11) NOT NULL auto_increment,
ad_tmpl varchar(30) default NULL,
ad_file varchar(255) default NULL,
ad_url varchar(255) default NULL,
ad_text1 text,
ad_text2 text,
views_left int(11) default '0',
first_day date default NULL,
perpetual int(1) default '0',
last_seen datetime default NULL,
sponsor int(11) default NULL,
active int(1) default '0',
example int(1) default '0',
ad_title varchar(255) default NULL,
submitted_on datetime default NULL,
view_count int(11) default '0',
click_throughs int(11) default '0',
judged int(1) default '0',
reason text,
paid int(1) default '0',
purchase_size int(11) default '0',
purchase_price decimal(7,2) default '0.00',
judger int(11) default NULL,
approved int(1) default NULL,
impression_cache int(11) default '0',
pos int(5) NOT NULL default '1',
ad_sid varchar(20) default NULL,
PRIMARY KEY (ad_id),
KEY seen_active (active,last_seen,ad_tmpl),
KEY pos (pos)
)
]: You have an error in your SQL syntax near '---------------------------------------------------------
-- Server version 4.0.' at line 4
Dumping data into scoop... |
|
|
Story Views
|
|
25 Scoop users have viewed this story.
|
|
