- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Name: pascal
Subject: indexer -Ecreate fails on mysql
{sqldbms.c:3107} Query: CREATE TABLE cookies ( expires int,
secure char(1) CHARACTER SET latin1, domain text CHARACTER SET
latin1, path text CHARACTER SET latin1, name text,
value text )
SQL-server message: MySQL driver: #1064: 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 'CHARACTER SET latin1, path text
CHARACTER SET lati
MySQL driver: #1064: 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
'CHARACTER SET latin1, path text CHARACTER SET lati
SQL>'CREATE UNIQUE INDEX cookies_idx ON cookies (domain(128), path(255),
name(100), secure)'
{sqldbms.c:3107} Query: CREATE UNIQUE INDEX cookies_idx ON cookies
(domain(128), path(255), name(100), secure)
SQL-server message: MySQL driver: #1146: Table 'search.cookies' doesn't
exist
MySQL driver: #1146: Table 'search.cookies' doesn't exist
SQL>'CREATE INDEX cookies_time ON cookies (expires)'
{sqldbms.c:3107} Query: CREATE INDEX cookies_time ON cookies (expires)
SQL-server message: MySQL driver: #1146: Table 'search.cookies' doesn't
exist
MySQL driver: #1146: Table 'search.cookies' doesn't exist
SQL>SQL>SQL>SQL>SQL>SQL>'CREATE TABLE storedchk ( rec_id integer,
url_id integer )'
SQL>'CREATE INDEX storedchk_i ON storedchk (url_id)'
SQL>SQL>SQL>SQL>'CREATE TABLE cachedchk ( rec_id integer )'
SQL>'CREATE UNIQUE INDEX cachedchk_i ON cachedchk (rec_id)'
SQL>SQL>SQL>
29 queries sent, 26 succeeded, 3 failed
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
Read the full topic here:
http://www.dataparksearch.com/cgi-bin/simpleforum.cgi?fid=01;post=
