|
|
|
|
|
|
| Re: Step 2 installation error PLEASE HELP!!! [message #160684 is a reply to message #160680] |
Mon, 12 October 2009 22:38   |
Ripley
Messages: 3
Registered: October 2009
Karma: 0
|
Junior Member |
|
|
Sorry, root was not my user name  I noticed it just now..
okay, I will find out what is my ''valid pre-created database name'' and do next step 
added, now it writes:
Failed to create table "fud_mime" ("CREATE TABLE fud30_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 
What should I do? 
[Updated on: Mon, 12 October 2009 22:59] Report message to a moderator |
|
|
|
|
|
| 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: 0
|
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 |
|
|
|
|
|
| Re: Step 2 installation error PLEASE HELP!!! [message #160792 is a reply to message #160791] |
Sat, 24 October 2009 08:02 |
DimOK
Messages: 6
Registered: October 2009
Karma: 0
|
Junior Member |
|
|
lolm funny thing is that Ripley tried in on the same host... so it is probably problem of my own server - it doesn't creat tables containing 'h' letter...
Digging deeper...
request to db_query subroutine... comes already broken, so it is your's problem, haha 
in line 940 install.php if (!dbquery($q)) { - it is broken...
ok, it is get broken here:
if (($q = make_into_query(trim($q)))) {
Before this line request is ok, after - letters 'h' are changed to spaces...
tadam...
return trim(str_replace('{SQL_TABLE_PREFIX}', $_POST['DBHOST_TBL_PREFIX'], preg_replace('!\h+!', ' ', preg_replace('!\#.*$!s', '', $data))));
Go learning regexp's, guys
Afaik, there is no '\h' metasymbol, but i am not that good with regexp, to fix this line myself...
Well, this variant worked well...
return trim(str_replace('{SQL_TABLE_PREFIX}', $_POST['DBHOST_TBL_PREFIX'], preg_replace('!\h+!', 'h', preg_replace('!\#.*$!s', '', $data))));
I don't know why do you need this regexp, please take a closer look.
[Updated on: Sat, 24 October 2009 09:54] Report message to a moderator |
|
|
|
|
|
| Re: Step 2 installation error PLEASE HELP!!! [message #160798 is a reply to message #160796] |
Sat, 24 October 2009 12:29 |
DimOK
Messages: 6
Registered: October 2009
Karma: 0
|
Junior Member |
|
|
Well, but why do tou need that stuff there anyway? It is installation script, all files are come exactly the way you want them, why making it that difficult...
i don't know whether mine is old or new, but i think it is ok...
Installed Packages
Name : pcre
Arch : x86_64
Version : 6.6
Release : 2.el5_1.7
Size : 227 k
Repo : installed
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
) 1 Vote
]