From: <sac...@un...> - 2007-08-12 07:36:51
|
Thank you for the quick reply! I did not receive this email. So I just copied the text from the archieves, thereby probably creating a new thread... sorry. > Oops, upgrade error. I forgot something. > Best is to use your phpMyAdmin with the following snippet: > > ALTER TABLE accesslog CHANGE remote_host VARCHAR(100); > > <enter> // this may fail. Failed indeed: #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 'VARCHAR(100)' at line 1 > ALTER TABLE link ADD relation INT DEFAULT 0; > CREATE INDEX link_relation ON link (relation); > > <enter> // this is required. This worked! > And then optionally again ?action=3Dupgrade to fill in the relations. This failed, seemingly, 3Dupgrade is an unknown action in my setup: ...(snipped some text) [nativecode=1054 ** Unknown column 'cached_html' in 'field list']) * lib/main.php:873 Notice[1024]: 3Dupgrade: Unknown action I tried ?upgrade instead. With this, the migration went further as before, but still failed: Upgrading this PhpWiki check for necessary database updates - SQL db version: we want 1030.14 db version: we have 0 Backend type: mysql check for table session ...OK check for table pref ...OK check for table member ...OK Rebuild entire database to upgrade relation links ... OK check for table accesslog ...OK check for table rating ...OK check for new session.sess_ip column ... SKIP check for mysql session.sess_id sanity ... Fatal Error: lib/WikiDB/backend/PearDB.php:1059 Error[256]: WikiDB_backend_PearDB_mysql: fatal database error * DB Error: syntax error * (DESCRIBE [nativecode=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 '' at line 1]) * lib/upgrade.php:472 Notice[8]: Undefined variable: DBParams lib/WikiDB/backend/PearDB.php:1151 Warning[2]: mysql_list_fields() [<a href='function.mysql-list-fields'>function.mysql-list-fields</a>]: Unable to save MySQL query result lib/WikiDB/backend/PearDB.php:1152 Warning[512]: /home/httpd/vhosts/scanita.net/httpdocs/phpwiki/lib/WikiDB/backend/PearDB.php:1152 Table 'spice_phpwiki.' doesn't exist (spice_phpwiki is the name of the DB as well as the name of the admin user) Is there a bug in upgrade.php or do you think there is a problem with my settings? -Sacha |
From: <sac...@gm...> - 2007-08-11 21:34:44
|
Thank you for the quick reply! I did not receive this email. So I just copied the text from the archieves, thereby probably creating a new thread... sorry. > Oops, upgrade error. I forgot something. > Best is to use your phpMyAdmin with the following snippet: > > ALTER TABLE accesslog CHANGE remote_host VARCHAR(100); > > <enter> // this may fail. Failed indeed: #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 'VARCHAR(100)' at line 1 > ALTER TABLE link ADD relation INT DEFAULT 0; > CREATE INDEX link_relation ON link (relation); > > <enter> // this is required. This worked! > And then optionally again ?action=3Dupgrade to fill in the relations. This failed, seemingly, 3Dupgrade is an unknown action in my setup: ...(snipped some text) [nativecode=1054 ** Unknown column 'cached_html' in 'field list']) * lib/main.php:873 Notice[1024]: 3Dupgrade: Unknown action I tried ?upgrade instead. With this, the migration went further as before, but still failed: Upgrading this PhpWiki check for necessary database updates - SQL db version: we want 1030.14 db version: we have 0 Backend type: mysql check for table session ...OK check for table pref ...OK check for table member ...OK Rebuild entire database to upgrade relation links ... OK check for table accesslog ...OK check for table rating ...OK check for new session.sess_ip column ... SKIP check for mysql session.sess_id sanity ... Fatal Error: lib/WikiDB/backend/PearDB.php:1059 Error[256]: WikiDB_backend_PearDB_mysql: fatal database error * DB Error: syntax error * (DESCRIBE [nativecode=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 '' at line 1]) * lib/upgrade.php:472 Notice[8]: Undefined variable: DBParams lib/WikiDB/backend/PearDB.php:1151 Warning[2]: mysql_list_fields() [<a href='function.mysql-list-fields'>function.mysql-list-fields</a>]: Unable to save MySQL query result lib/WikiDB/backend/PearDB.php:1152 Warning[512]: /home/httpd/vhosts/scanita.net/httpdocs/phpwiki/lib/WikiDB/backend/PearDB.php:1152 Table 'spice_phpwiki.' doesn't exist (spice_phpwiki is the name of the DB as well as the name of the admin user) Is there a bug in upgrade.php or do you think there is a problem with my settings? -Sacha |
From: Reini U. <ru...@x-...> - 2007-08-12 13:08:55
|
Greetings to Basel. Sacha Schär schrieb: > Thank you for the quick reply! I did not receive this email. So I just > copied the text from the archieves, thereby probably creating a new > thread... sorry. > > > > Oops, upgrade error. I forgot something. > > Best is to use your phpMyAdmin with the following snippet: > > > > ALTER TABLE accesslog CHANGE remote_host VARCHAR(100); > > > > <enter> // this may fail. > > Failed indeed: > > #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 'VARCHAR(100)' at line 1 > > > > ALTER TABLE link ADD relation INT DEFAULT 0; > > CREATE INDEX link_relation ON link (relation); > > > > <enter> // this is required. > > This worked! > > > And then optionally again ?action=3Dupgrade to fill in the relations. A mailer error. I meant ?action=upgrade of course ... > This failed, seemingly, 3Dupgrade is an unknown action in my setup: > > ...(snipped some text) > [nativecode=1054 ** Unknown column 'cached_html' in 'field list']) > * > > lib/main.php:873 Notice[1024]: 3Dupgrade: Unknown action > > > I tried ?upgrade instead. With this, the migration went further as > before, but still failed: > > Upgrading this PhpWiki > check for necessary database updates - SQL > db version: we want 1030.14 > db version: we have 0 > Backend type: mysql > check for table session ...OK > check for table pref ...OK > check for table member ...OK > Rebuild entire database to upgrade relation links ... OK > check for table accesslog ...OK > check for table rating ...OK > check for new session.sess_ip column ... SKIP > check for mysql session.sess_id sanity ... > Fatal Error: > > lib/WikiDB/backend/PearDB.php:1059 Error[256]: > WikiDB_backend_PearDB_mysql: fatal database error > > * DB Error: syntax error > * (DESCRIBE [nativecode=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 '' at line 1]) > * > > lib/upgrade.php:472 Notice[8]: Undefined variable: DBParams This error is not fatal. mysql session.sess_id sanity is not so important in your case. > lib/WikiDB/backend/PearDB.php:1151 Warning[2]: mysql_list_fields() [<a > href='function.mysql-list-fields'>function.mysql-list-fields</a>]: > Unable to save MySQL query result > > lib/WikiDB/backend/PearDB.php:1152 Warning[512]: > /home/httpd/vhosts/scanita.net/httpdocs/phpwiki/lib/WikiDB/backend/PearDB.php:1152 > Table 'spice_phpwiki.' doesn't exist > > > (spice_phpwiki is the name of the DB as well as the name of the admin user) > > Is there a bug in upgrade.php or do you think there is a problem with my > settings? Both. A bug in upgrade and an intermediate mysql schema. Thanks for using DEBUG to get the failing upgrade lines. I can fix it now. Does the wiki work? > ...(snipped some text) > [nativecode=1054 ** Unknown column 'cached_html' in 'field list']) We still seem to need 'cached_html' Strange, this should have been there since 1.3.11. Try ALTER TABLE page ADD cached_html MEDIUMBLOB; But I rather believe upgrade fails in mysql_list_fields(). -- Reini Urban http://phpwiki.org/ http://murbreak.at/ http://helsinki.at/ http://spacemovie.mur.at/ |
From: Reini U. <ru...@x-...> - 2007-08-12 14:35:14
|
Reini Urban schrieb: > Greetings to Basel. > Sacha Schär schrieb: >> lib/WikiDB/backend/PearDB.php:1059 Error[256]: >> WikiDB_backend_PearDB_mysql: fatal database error >> >> * DB Error: syntax error >> * (DESCRIBE [nativecode=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 '' at line 1]) >> * >> >> lib/upgrade.php:472 Notice[8]: Undefined variable: DBParams > > This error is not fatal. > mysql session.sess_id sanity is not so important in your case. FYI: The fix for this error is in lib/upgrade.php function CheckDatabaseUpdate() { global $DBAuthParams, $DBParams; -- Reini Urban http://phpwiki.org/ http://murbreak.at/ http://helsinki.at/ http://spacemovie.mur.at/ |
From: <sac...@gm...> - 2007-08-12 15:34:39
|
Greetings to Austria and many thanks for all your help! > Does the wiki work? > > > ...(snipped some text) > > [nativecode=1054 ** Unknown column 'cached_html' in 'field list']) > > We still seem to need 'cached_html' > Strange, this should have been there since 1.3.11. Try > > ALTER TABLE page ADD cached_html MEDIUMBLOB; > > But I rather believe upgrade fails in mysql_list_fields(). As far as I can tell the wiki works now, _after_ applying the SQL patch above! (from your other mail) > FYI: The fix for this error is in lib/upgrade.php > > function CheckDatabaseUpdate() { > global $DBAuthParams, $DBParams; After fixing this, ?action=upgrade dies at the following check: check for mysql LOCK TABLE privilege ...lock_tables_priv missing. The DB Admin must run mysql_fix_privilege_tables Is 'mysql_fix_privilege_tables' some file or action that is provided with PHPWiki? I can not find anything like that. If it is something only the host provider can do, how should I instruct him? Can I savely run the wiki now or should I fix the problem above first? -Sacha PS: One minor glitch: Seemingly, I can no longer login into the wiki as 'SachaSchär'. Is this because of the umlaut? Anyway, no real problem, I'm just curious... |
From: Reini U. <ru...@x-...> - 2007-08-12 16:06:44
|
Sacha Schär schrieb: > Greetings to Austria and many thanks for all your help! > As far as I can tell the wiki works now, _after_ applying the SQL patch > above! Ah, good. > (from your other mail) > > FYI: The fix for this error is in lib/upgrade.php > > > > function CheckDatabaseUpdate() { > > global $DBAuthParams, $DBParams; > > After fixing this, ?action=upgrade dies at the following check: > check for mysql LOCK TABLE privilege ...lock_tables_priv missing. > The DB Admin must run mysql_fix_privilege_tables > > > Is 'mysql_fix_privilege_tables' some file or action that is provided > with PHPWiki? I can not find anything like that. > If it is something only the host provider can do, how should I instruct > him? This error says that it seems that wikiuser has no privileges to LOCK tables. Your provider has to grant you LOCK TABLE privileges for your own databases, best done with mysql_fix_privilege_tables. However if you CAN edit pages, you don't need this and the upgrade check is wrong. > Can I savely run the wiki now or should I fix the problem above first? > PS: One minor glitch: Seemingly, I can no longer login into the wiki as > 'SachaSchär'. Is this because of the umlaut? Anyway, no real problem, > I'm just curious... Hmm, that depends on many other things. If the new database has a different default locale, it will lead to those effects. -- Reini Urban http://phpwiki.org/ http://murbreak.at/ http://helsinki.at/ http://spacemovie.mur.at/ |