Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2006-03-03 22:40:24
- Juego
- New Member
- Registered: 2005-01-17
- Posts: 5
Database transfer from 1.0rc3 to 4.0.3 (r1188)
Hello
I have to transfer a textpattern website hosted on free.fr to edelweisshosting.
On free.fr: txp version: 1.0rc3 MySQL version: 4.1.15
On edelweisshosting: txp version 4.0.3 and MySQL version: 4.0.25
I ran into a lot of problems backing up the database from free.fr and importing it to edelweisshosting. I kept getting errors which I think are related to the MySQL versions… I had to backup it with a MYSQL323 compatibility to be able to import it on the other side.
I tought this would be it with the problems but it wasn’t.
Everything seemed to have been imported allright, but as I tried to create a new article on the new website, it appeared to be saved correctly, but when I would re-edit it, the date would change to january 1970 and all informations (text and title) would have disappeared.
Also, I was not able to create new categories.
On the other hand, I can create new sections and re-edit previously posted articles (from the old database) without problems.
So I don’t know what’s going on. I’m a bit lost. Is it because of MySQL version stuff (and the fact that I downgrade the content of it). Or is it because of the upgrade from Textpattern version? or else…?
Any help appriciated. Thanks
Ju
Offline
Re: Database transfer from 1.0rc3 to 4.0.3 (r1188)
So I don’t know what’s going on. I’m a bit lost. Is it because of MySQL version stuff (and the fact that I downgrade the content of it). Or is it because of the upgrade from Textpattern version? or else…?
That’s why it’s a good idea to only change one thing at a time, and check for any problems then, before doing anything else. So either upgrade first, and do the upgrade then, or the other way around.
Also can you be more specific on the mysql-versions on the two servers?
Can you post your diagnostics, too?
Offline
#3 2006-03-04 10:29:04
- Juego
- New Member
- Registered: 2005-01-17
- Posts: 5
Re: Database transfer from 1.0rc3 to 4.0.3 (r1188)
Yes, you’re right, I should have done one thing at a time.
So my first porblem came from the sql transfer.
On free.fr: it’s MySQL 4.1.15 on the server sql.free.fr with phpMyAdmin 2.6.3-pl1 (language french) UTF-8 Unicode (utf8) and connexion collation utf8_general_ci
On edelweisshosting: MySQL 4.0.25 on localhost with phpMyAdmin 2.6.2-pl1 (language french) and no connexion collation information
When I import the .sql file I get this kind of error:
<pre>
<code>
SQL request:
CREATE TABLE textpattern(
ID int( 11 ) NOT NULL AUTO_INCREMENT ,
Posted datetime NOT NULL default ’0000-00-00 00:00:00’,
AuthorID varchar( 64 ) COLLATE latin1_general_ci NOT NULL default ‘’,
LastMod datetime NOT NULL default ’0000-00-00 00:00:00’,
LastModID varchar( 64 ) COLLATE latin1_general_ci NOT NULL default ‘’,
Title varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
Title_html varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
Body mediumtext COLLATE latin1_general_ci NOT NULL ,
Body_html mediumtext COLLATE latin1_general_ci NOT NULL ,
Excerpt text COLLATE latin1_general_ci NOT NULL ,
Excerpt_html mediumtext COLLATE latin1_general_ci NOT NULL ,
Image varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
Category1 varchar( 128 ) COLLATE latin1_general_ci NOT NULL default ‘’,
Category2 varchar( 128 ) COLLATE latin1_general_ci NOT NULL default ‘’,
Annotate int( 2 ) NOT NULL default ‘0’,
AnnotateInvite varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
`Status` int( 2 ) NOT NULL default ‘4’,
textile_body int( 2 ) NOT NULL default ‘1’,
textile_excerpt int( 2 ) NOT NULL default ‘1’,
Section varchar( 64 ) COLLATE latin1_general_ci NOT NULL default ‘’,
override_form varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
Keywords varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
url_title varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
custom_1 varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
custom_2 varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
custom_3 varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
custom_4 varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
custom_5 varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
custom_6 varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
custom_7 varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
custom_8 varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
custom_9 varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
custom_10 varchar( 255 ) COLLATE latin1_general_ci NOT NULL default ‘’,
uid varchar( 32 ) COLLATE latin1_general_ci NOT NULL default ‘’,
feed_time date NOT NULL default ’0000-00-00’,
PRIMARY KEY ( ID ) ,
KEY categories_idx( Category1( 10 ) , Category2( 10 ) ) ,
KEY Posted( Posted ) ,
FULLTEXT KEY searching( Title, Body )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci PACK_KEYS =1
- - 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 ‘collate latin1_general_ci NOT NULL default ‘’, LastMod dateti
</code>
</pre>
I found a workaround this error by selecting SQL export compatibility MYSQL323 in SQL options from the “Export” menu.
And the diagnostics you ask about. If it’s the one from Textpattern, here it is: (I change the language to English(US) to share it with you but normally, it’s in french)
on free.fr:
<pre>
<code>
Textpattern version: 1.0rc3
Document root: /var/www/free.fr/e/1/nomades.land
$path_to_site: /var/www/free.fr/e/1/nomades.land
Textpattern path: /var/www/free.fr/e/1/nomades.land/textpattern
Permanent link mode: messy
Temp folder: /var/www/free.fr/e/1/nomades.land
Site URL: nomades.land.free.fr
PHP version: 4.3.10
Register globals: 1
Magic quotes: 1/0
Locale: en_US.UTF-8
Server: Apache/ProXad [Feb 19 2006 23:15:13]
Pre-flight check:
————————————
/var/www/free.fr/e/1/nomades.land/textpattern/_update.php still exists
————————————
PHP extensions: xml, tokenizer/0.1, standard/4.3.10, session, pcre, overload, ctype, zlib/1.1, bcmath, bz2, calendar, curl, dba, domxml/20020815, exif/1.4 $Id: exif.c,v 1.118.2.29 2004/11/10 01:44:58 iliaa Exp $, gd, gettext, mcal, mcrypt, mhash, mysql, sockets, wddx, xslt
MD5 /include/txp_category.php: 881485b4606ee5faed24fdabdd2e1ee2
MD5 /include/txp_plugin.php: 4099846c26d565559402b3d9909e3fa6
MD5 /include/txp_auth.php: bceb5557293bc417442c9cc653e7f62a
MD5 /include/txp_form.php: 8a21a3c6530fd6fc9eddc8071525b8f1
MD5 /include/txp_section.php: 7cb1e501e575f453fe1c6e057334352f
MD5 /include/txp_tag.php: 4aa3471805cb68d2bdbd1a3ae492ce43
MD5 /include/txp_list.php: 4f69d5131bb7ce9d7ca87838314c378c
MD5 /include/txp_page.php: d8552ad0ae2443b28dafc106893dbe3d
MD5 /include/txp_discuss.php: 6b98c5c40e65c9e799e1908b8af266a6
MD5 /include/txp_prefs.php: d729a5c733dedc2423b84bd16d5dfae9
MD5 /include/txp_log.php: 364047209258d266e7e496bec29b8067
MD5 /include/txp_preview.php: 5bad58d9871e0e50d0ac4491712543e5
MD5 /include/txp_image.php: b0dcbf9599f342a0bd08d84fdaf8f5e9
MD5 /include/txp_article.php: 5ee3fefc53779aa9df87d7ab73df7229
MD5 /include/txp_css.php: 4f3c0f0e4abc81ec53c8bbfcad5d5a7f
MD5 /include/txp_admin.php: 4402b14b04201e393cd51898f4f00ae5
MD5 /include/txp_link.php: 288296ccaf0c87be6baf4ae811898af2
MD5 /include/txp_diag.php: 6464490b8031a7de93dbb0501a133e3c
MD5 /lib/admin_config.php: 840deaf145eeb21a8925639f594a67b5
MD5 /lib/txplib_misc.php: 922ad334714dc69cf058a215df24aa6b
MD5 /lib/taglib.php: 5e74f28cc9a6e6aa0aa1ffe926c3daab
MD5 /lib/txplib_head.php: 65b6c5fe591378e99b77b11a2784ba71
MD5 /lib/classTextile.php: 78d0075fcabc129b3d5ca088c9173cf4
MD5 /lib/txplib_html.php: 3de1d5a82b2bf9f9bf348d92665d4955
MD5 /lib/txplib_db.php: 82af2b5a8111536fdd69d245b6c8f713
MD5 /lib/IXRClass.php: 1e8250e604ce1be76f703a123ef5e782
MD5 /lib/txplib_forms.php: 7384d046eac1ef51ec086a49dbe397bf
MD5 /publish/taghandlers.php: 46b7920db8bc36fe2ebfbe8976d53fac
MD5 /publish/atom.php: d4802b126058766826e6afb2d9f3933e
MD5 /publish/log.php: fdd14dd1315835d52123f8ec8ead89ce
MD5 /publish/comment.php: ee0e90ef3d6add6d97fda9560357f543
MD5 /publish/search.php: 786eb0425a1b2b5d6956089131e1ae28
MD5 /publish/rss.php: 415aff27e9c6f74237706dd4e60e1f85
MD5 /publish.php: 767a93ebda414ea326fd6be2a8cfb026
MD5 /index.php: 21a9206287d9fc3ce53cb2101c4bb410
MD5 /css.php: 1eb84831fb0a0416eb545d70c3979d51
</code>
</pre>
and on edelweisshosting:
<pre>
</code>
Textpattern version: 4.0.3 (r1188)
last_update: 2006-02-24 21:11:53/2006-03-03 21:03:46
Document root: /home/panda1/domains/nomadesland.net/public_html
$path_to_site: /home/panda1/domains/nomadesland.net/public_html
Textpattern path: /home/panda1/domains/nomadesland.net/public_html/textpattern
Permanent link mode: title_only
Temp folder: /tmp
Site URL: www.nomadesland.net
PHP version: 4.4.2
Register globals: 1
server_time: 2006-03-04 11:23:22
MySQL: 4.0.25-standard-log
Locale: en_US.UTF-8
Server: All attacks reported to ISP and local Police
Apache version: All attacks reported to ISP and local Police
php_sapi_mode: apache
os_version: Linux 2.6.10-1.771_FC2smp
Pre-flight check:
————————————
Clean URLs are only supported for apache, use at your own risk
————————————
.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/
<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteRule ^(.*) index.php </IfModule>#php_value register_globals 0
————————————
Charset (default/config): latin1/latin1
character_set: latin1
character_sets: latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
19 Tables: OK
PHP extensions: zip, xml, tokenizer/0.1, standard/4.4.2, sockets, session, posix, overload, mysql, mhash, mcrypt, mbstring, gettext, gd, ftp, curl, ctype, calendar, bcmath, zlib/1.1, pcre, openssl, apache, Zend Optimizer
/include/txp_category.php: r1154 (dffd7979531373149c74e3eedfbb50e2)
/include/txp_plugin.php: r1167 (c2c7d7fc1e4918c79cd3658c62e4fbda)
/include/txp_auth.php: r1166 (3e2eaca7b151e14561125ab68e722203)
/include/txp_form.php: r947 (c0e4393328985742bd81cda61d10d5ed)
/include/txp_section.php: r1154 (d85c1ce405fccd9dac364c8ef4eb72eb)
/include/txp_tag.php: r1134 (3e2dfbd6fdccf0693c147ba22a9705e7)
/include/txp_list.php: r1042 (e85d2de1c63b41f0e5bdcf268e3c487b)
/include/txp_page.php: r876 (e22dc37b465b87757722732a225b25f3)
/include/txp_discuss.php: r1170 (1e56e08cc95c255783410076db12529f)
/include/txp_prefs.php: r1170 (c806be1b1f238e75a5ff6b7cf8432d17)
/include/txp_log.php: r906 (68c4f32b70ce41a349f197b6bba6c200)
/include/txp_preview.php: r628 (a16f84b6610fc66db0bce51e25b7af34)
/include/txp_image.php: r1168 (e8ec79ff9b3a21c356ee23da7973b1f0)
/include/txp_article.php: r1170 (88689d7469d16c13d51bd4adff03ebd7)
/include/txp_css.php: r922 (0c596d9968052b89581d1ca65a77c5de)
/include/txp_admin.php: r1074 (7e87ff0e29101593fb170b1a2de9fd59)
/include/txp_link.php: r1154 (7c0c55ff6580793dff0626f169e64ad6)
/include/txp_diag.php: r1154 (5d66b90f7e7720dd0e3526ca1b24cf89)
/lib/admin_config.php: r877 (9aea12193cc76eea1964eb0383ec6513)
/lib/txplib_misc.php: r1170 (7000a1b27aa40c90978211e6cff358ec)
/lib/taglib.php: r628 (493878f922262157601c26a999a1c478)
/lib/txplib_head.php: r1183 (fb85b66b4e379476935233f844844bef)
/lib/classTextile.php: r1141 (b066c2bfa94a26ae3d70b245dcf81369)
/lib/txplib_html.php: r1166 (bd11de6e6daa3391eab75a46db55ae36)
/lib/txplib_db.php: r1170 (5a2c3a1e328cd343a067cbb8fd25cd79)
/lib/IXRClass.php: r765 (2efb0fb05b55c634072b0bae9af38bdd)
/lib/txplib_forms.php: r950 (74da2c67abe4786c353ea416c13656eb)
/publish/taghandlers.php: r1188 (4e8eaeb0543d8fde09d6e423af4253b9)
/publish/atom.php: r1117 (14c1aa23c708898d7723b3d6b9c89050)
/publish/log.php: r864 (c3d16d3dfe375819a19fcd62398e4b86)
/publish/comment.php: r1187 (d55dde574418d2eaf6a394d703056d9a)
/publish/search.php: r884 (80f942f1dc301857c2fa9dcb16aa1246)
/publish/rss.php: r1099 (ce0d82b9435d8f1de01c8e2b6c585f93)
/publish.php: r1186 (d5c20bf2298e87969575f9e622bf2797)
/index.php: r1172 (52f753ebb51c1f7d5312485d9dbad7e4)
/css.php: r944 (df1c754417bdfb4e97a2c83ae5b454ee)
</code>
</pre>
Thank a lot for your help Sencer. I greatly appreciate.
By any chance, do you know where could I still download Textpattern 1.0rc3 ??
Thanks
Last edited by Juego (2006-03-04 10:33:13)
Offline