Welcome to Geeklog, Anonymous Friday, November 29 2024 @ 10:48 pm EST
Geeklog Forums
Migrate version 1.4.1 to 1.8.1
DWS
Anonymous
Is it possible to migrate from GL 1.4.1 to 1.8.1? I get a white page, I review error.log and the apache log, but I can't see any mistake.
9
10
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Yes, upgrades from any older version should be possible.
Check that your webserver setup meets the requirements (PHP 5.2.0 or later, MySQL 4.1.3 or later). If that's not the problem, see the FAQ article Blank page for some tips to get it to display an error message so that we can see what the problem is.
bye, Dirk
Check that your webserver setup meets the requirements (PHP 5.2.0 or later, MySQL 4.1.3 or later). If that's not the problem, see the FAQ article Blank page for some tips to get it to display an error message so that we can see what the problem is.
bye, Dirk
7
5
Quote
DWS
Anonymous
Actually I have another sites with GL 1.8.1 and I don't have problems. I tried with the tips but I can't see the problem 
9
9
Quote
DWS
Anonymous
Just I want to import news,staticpages and users. I can install a new version and import the data from these tables manually? What another tables it's necessary to import?
10
5
Quote
DWS
Anonymous
Well I used this code:
set_error_handler('errorHandler');
function errorHandler( $errno, $errstr, $errfile, $errline, $errcontext)
{
echo 'Into '.__FUNCTION__.'() at line '.__LINE__.
"\n\n---ERRNO---\n". print_r( $errno, true).
"\n\n---ERRSTR---\n". print_r( $errstr, true).
"\n\n---ERRFILE---\n". print_r( $errfile, true).
"\n\n---ERRLINE---\n". print_r( $errline, true).
"\n\n---ERRCONTEXT---\n".print_r( $errcontext, true).
"\n\nBacktrace of errorHandler()\n".
print_r( debug_backtrace(), true);
}
And a see this:
Into errorHandler() at line 43 ---ERRNO--- 256 ---ERRSTR--- 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 'TYPE=MyISAM' at line 8 ...........................
Text Formatted Code
set_error_handler('errorHandler');
function errorHandler( $errno, $errstr, $errfile, $errline, $errcontext)
{
echo 'Into '.__FUNCTION__.'() at line '.__LINE__.
"\n\n---ERRNO---\n". print_r( $errno, true).
"\n\n---ERRSTR---\n". print_r( $errstr, true).
"\n\n---ERRFILE---\n". print_r( $errfile, true).
"\n\n---ERRLINE---\n". print_r( $errline, true).
"\n\n---ERRCONTEXT---\n".print_r( $errcontext, true).
"\n\nBacktrace of errorHandler()\n".
print_r( debug_backtrace(), true);
}
And a see this:
Text Formatted Code
Into errorHandler() at line 43 ---ERRNO--- 256 ---ERRSTR--- 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 'TYPE=MyISAM' at line 8 ...........................
6
12
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Ah, okay. That's a known bug and happens with MySQL 5.5, which dropped the "TYPE" keyword and only accepts "ENGINE" now.
To fix, you would have to edit the following files:
plugins/links/sql/mysql_updates.php
plugins/polls/sql/mysql_updates.php
sql/updates/mysql_1.4.1_to_1.5.0.php
sql/updates/mysql_1.5.2_to_1.6.0.php
Search for: TYPE=MyISAM and replace it with: ENGINE=MyISAM (there may be more than one occurence per file). Then restore your database and try the update again.
I guess we should consider a 1.8.2 release to fix this issue until 2.0.0 is ready ...
bye, Dirk
To fix, you would have to edit the following files:
plugins/links/sql/mysql_updates.php
plugins/polls/sql/mysql_updates.php
sql/updates/mysql_1.4.1_to_1.5.0.php
sql/updates/mysql_1.5.2_to_1.6.0.php
Search for: TYPE=MyISAM and replace it with: ENGINE=MyISAM (there may be more than one occurence per file). Then restore your database and try the update again.
I guess we should consider a 1.8.2 release to fix this issue until 2.0.0 is ready ...
bye, Dirk
8
8
Quote
DWS
Anonymous
Thank you Dirk, this work, but now a I can't create a backup. I get this message:
256 - An SQL error has occurred. Please see error.log for details. @ /var/www/ime/system/databases/mysql.class.php line 260
array(3) {
["sql"]=>
string(16) "SHOW TABLE TYPES"
["ignore_errors"]=>
int(0)
["result"]=>
bool(false)
}
error.log
Mon Sep 24 19:20:20 2012 - 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 'TYPES' at line 1. SQL in question: SHOW TABLE TYPES
Text Formatted Code
256 - An SQL error has occurred. Please see error.log for details. @ /var/www/ime/system/databases/mysql.class.php line 260
array(3) {
["sql"]=>
string(16) "SHOW TABLE TYPES"
["ignore_errors"]=>
int(0)
["result"]=>
bool(false)
}
error.log
Text Formatted Code
Mon Sep 24 19:20:20 2012 - 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 'TYPES' at line 1. SQL in question: SHOW TABLE TYPES
9
8
Quote
All times are EST. The time is now 10:48 pm.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content