| Re: Step 2 installation error PLEASE HELP!!! [message #160790 is a reply to message #160686] |
Sat, 24 October 2009 07:34   |
DimOK
Messages: 6
Registered: October 2009
Karma:
|
Junior Member |
|
|
Same problem too, didn't change anything, got installation file from 'stable 3.00' release fudforum.org/releases/FUDforum_3-0-0.tar.gz
Failed to create table "fud_mime" ("CREATE TABLE new_mime ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, fl_ext VARCHAR(10) NOT NULL DEFAULT '', mime_ dr VARCHAR(255) NOT NULL DEFAULT '', descr VARCHAR(255), icon VARCHAR(100) NOT NULL DEFAULT 'unknown.gif' ) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci"), SQL Reason: 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 'dr VARCHAR(255) NOT NULL DEFAULT '', descr VARCHAR(255), icon VARCHAR(100) N' at line 5
But in fud_mime.tbl everything is correct...
If i change mime_hdr in .tbl file to, like, mime_hr or anything - it works well... strange bug...
Problems again... after i manually install this table...
Failed to create table "fud_thread_view" ("CREATE TABLE new_tv_1 ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, seq INT NOT NULL, t read_id INT NOT NULL, iss INT NOT NULL ) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci"), SQL Reason: 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 'read_id INT NOT NULL, iss INT NOT NULL ) DEFAULT CHARACTER SET utf8 COLLATE ut' at line 5
Some problems with letters 'h' in installation file, they are changed to spaces during install...
Before insert int is ok, from intall.php
echo ($q);
if (($q = make_into_query(trim($q)))) {
if (!dbquery($q)) {
seterr('DBHOST_DBNAME', 'Failed to create table "'.basename($t, '.tbl').'" ("'.$q.'"), SQL Reason: '.dberror());
break 2;
it echoes correct value, with 'h'... but in request - it is without it...
[Updated on: Sat, 24 October 2009 07:58] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
) 1 Vote
]