-
Edit a sql file mysql.prattcms.sql in your ../admin/install/sql
folder and remove ; (semicolon) symbol at the end of each
line with insert instruction.
example is:
INSERT INTO `installed_templates` VALUES (2, 'Blue', '1');
shoud be:
INSERT INTO `installed_templates` VALUES (2, 'Blue', '1')
There are more lines to check.
2005-02-09 09:30:36 UTC by nobody
-
Logged In: YES
user_id=848685
There was a bug report for this... you can easely solve it by
deleting every ';' from the file
admin/install.sql/mysql.prattcms.sql.
2004-12-06 15:49:21 UTC by mispunt
-
Logged In: YES
user_id=848685
I think it is a bug...
2004-12-06 15:43:56 UTC by mispunt
-
Is this project dead? if so, could I take over all the stuff and continuing developing?.
2004-12-06 14:45:50 UTC by mispunt
-
Logged In: YES
user_id=944631
I'm getting a similar error:
Error: the query number 27 died!
db_error Object
(
[error_message_prefix] =>
[mode] => 1
[level] => 1024
[code] => -2
[message] => DB Error: syntax error
[userinfo] => INSERT INTO `installed_templates` VALUES
(2, 'Blue', '1');
[nativecode=1064 ** You have an error in your SQL syntax
near ';
'...
2004-01-06 04:18:23 UTC by tridentgirl
-
the include_path in the global.var.php is set like this:
ini_set("include_path",".:" . $PRATTCMS_dir . "pear:" .
$PRATTCMS_dir . "smarty:" . $PRATTCMS_dir);
but on windows it must be
ini_set("include_path",".;" . $PRATTCMS_dir . "pear;" .
$PRATTCMS_dir . "smarty;" . $PRATTCMS_dir);
thx :D.
2003-11-12 20:18:29 UTC by nikotto
-
Logged In: YES
user_id=417235
i got the same error...
just open admin/install/sql/mysql-prattcms.sql and remove
all ';' at the end of the queryies! then it will work..
i don't know if this is just with out mysql-version?! or is
it a bug?.
2003-11-12 20:11:26 UTC by nikotto
-
Trying to insert the default database structure and
information into the database, I received the following
error message:
Error: the query number 28 died!
db_error Object
(
[error_message_prefix] =>
[mode] => 1
[level] => 1024
[code] => -2
[message] => DB Error: syntax error
[userinfo] => INSERT INTO `installed_templates`
VALUES (2...
2003-10-01 23:00:16 UTC by etchever
-
PHP 4.3.2
MySQL 3.23.54
db 'pratt' has all permissions except grant and
references.
CREATE TABLE installed_templates (
id int(11) NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
value varchar(50) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
the script while excuting this query:
INSERT INTO `installed_templates` VALUES (2,
'Blue', '1');...
2003-09-09 14:55:36 UTC by rolsch
-
How do I read the documentation, do I need to upload it to a php enabled server?.
2003-08-28 01:37:47 UTC by anselm1109
