Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Image upload problem.
Mmm. I’m stuck then I’m afraid because my next option is to save all my templates and CSS to text files on my PC, delete the database and textpattern files and re-install. Then copy my templates and CSS back in when it’s running properly. Someone else may have a better solution though so you might want to wait a bit before you do that. Sorry I can’t be of more help.
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline
#14 2005-12-02 15:21:57
- Nonsense
- Member
- Registered: 2005-11-25
- Posts: 53
Re: Image upload problem.
That figures.
Ok.
Thanks anyway.
Offline
Re: Image upload problem.
Can you please post your high level diagnostics. Thanks.
Offline
#16 2005-12-02 16:55:00
- Nonsense
- Member
- Registered: 2005-11-25
- Posts: 53
Re: Image upload problem.
txp_version: 4.0.2 (r1076)
last_update: 2005-11-24 22:05:15/2005-11-29 08:36:03
document_root: /usr/local/www/htdocs
$path_to_site: /usr/local/www/htdocs/kundwebb/adk/se
txp_path: /usr/local/www/htdocs/kundwebb/adk/se/textpattern
permlink_mode: section_id_title
tempdir: /usr/local/www/htdocs/kundwebb/adk/se/textpattern/tmp
web_domain: aron.ldc.lu.se/kundwebb/adk/se
TZ: MET
php_version: 4.3.7
server_time: 2005-12-02 17:57:14
MySQL: 3.23.53
locale: en_GB
server: Apache/1.3.31 (Unix) PHP/4.3.7
apache_version: Apache/1.3.31 (Unix) PHP/4.3.7
htaccess_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 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
18 Tables: OK
php_extensions: xml, tokenizer/0.1, standard/4.3.7, session, posix, pcre, overload, mysql, ctype, apache
/include/txp_category.php: r901 (ced49a43561099e1652fccb7880b8f66)
/include/txp_plugin.php: r902 (20ba701396c318619a4e00681af8b228)
/include/txp_auth.php: r928 (4cfa9ec7960f80308c9392cec5722616)
/include/txp_form.php: r947 (c0e4393328985742bd81cda61d10d5ed)
/include/txp_section.php: r904 (3575f34afd7bf1400ecb7926483fcbd2)
/include/txp_tag.php: r982 (c4f3b1cd5aa07a45f6218ec2a6befe0f)
/include/txp_list.php: r1042 (e85d2de1c63b41f0e5bdcf268e3c487b)
/include/txp_page.php: r876 (e22dc37b465b87757722732a225b25f3)
/include/txp_discuss.php: r1056 (1e6c25bf973a445a9e6ff710064f01f9)
/include/txp_prefs.php: r1026 (6c0696f2147c45276380a7438dbd1575)
/include/txp_log.php: r906 (68c4f32b70ce41a349f197b6bba6c200)
/include/txp_preview.php: r628 (a16f84b6610fc66db0bce51e25b7af34)
/include/txp_image.php: r1042 (f0460bd2917bf35304a4f6bd881781ee)
/include/txp_article.php: r1049 (7dfdffb58a90570e8ad90debc1017b0c)
/include/txp_css.php: r922 (0c596d9968052b89581d1ca65a77c5de)
/include/txp_admin.php: r1074 (7e87ff0e29101593fb170b1a2de9fd59)
/include/txp_link.php: r1042 (f4e99d4b37e5c80f3c9fb2f1b1c08e3d)
/include/txp_diag.php: r1075 (d4b97f820b0ea9abe593cb74bf3891c2)
/lib/admin_config.php: r877 (9aea12193cc76eea1964eb0383ec6513)
/lib/txplib_misc.php: r1064 (c4b8079db64c3fbe57ea961181d88512)
/lib/taglib.php: r628 (493878f922262157601c26a999a1c478)
/lib/txplib_head.php: r1055 (a8e03ea3e927ddde5fc25434a506dfb7)
/lib/classTextile.php: r1072 (52c3c2efdde23f52efdd0d7728c6986f)
/lib/txplib_html.php: r1002 (e8f4c2552170d92d5d353dae725c8bba)
/lib/txplib_db.php: r1064 (7dc8e32e097645d4340de2f809896521)
/lib/IXRClass.php: r765 (2efb0fb05b55c634072b0bae9af38bdd)
/lib/txplib_forms.php: r950 (74da2c67abe4786c353ea416c13656eb)
/publish/taghandlers.php: r1067 (1e9624108bdd485003629ae239619414)
/publish/atom.php: r1037 (30aea53e1c1fce877a10d2d9fa3ce90c)
/publish/log.php: r864 (c3d16d3dfe375819a19fcd62398e4b86)
/publish/comment.php: r1057 (7db181efda097083988e47eb00960915)
/publish/search.php: r884 (80f942f1dc301857c2fa9dcb16aa1246)
/publish/rss.php: r1037 (6848c34e120c99b6889b7f19c421b076)
/publish.php: r1073 (700374ed1a9cb57b5afc355ac977daad)
/index.php: r1076 (482a2e752575c2b7b620a86520b99303)
/css.php: r944 (df1c754417bdfb4e97a2c83ae5b454ee)
Last edited by Nonsense (2005-12-02 16:57:26)
Offline
#17 2005-12-02 17:06:42
- KurtRaschke
- Plugin Author
- Registered: 2004-05-16
- Posts: 275
Re: Image upload problem.
That’s awfully peculiar. It’s as though the schema for <code>txp_image</code> has gotten fouled up somehow.
I’d suggest dropping <code>txp_image</code> and recreating it from scratch with the right schema, but I can’t advise how to do it through phpMyAdmin, as I only have experience with the mysql command-line client.
-Kurt
Last edited by KurtRaschke (2005-12-02 17:07:05)
kurt@kurtraschke.com
Offline
#18 2005-12-02 17:09:50
- Nonsense
- Member
- Registered: 2005-11-25
- Posts: 53
Re: Image upload problem.
Yes I have considered that.
But if I drop txp_image, will Textpattern replace it automaticly?
Offline
#19 2005-12-02 17:10:59
- Nonsense
- Member
- Registered: 2005-11-25
- Posts: 53
Re: Image upload problem.
No it didn’t.
Buggers.
Offline
#20 2005-12-02 17:14:28
- KurtRaschke
- Plugin Author
- Registered: 2004-05-16
- Posts: 275
Re: Image upload problem.
Well, if you have a way to run SQL, you can recreate it as such:
<pre><code>
CREATE TABLE `txp_image` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default ‘’,
`category` varchar(255) NOT NULL default ‘’,
`ext` varchar(20) NOT NULL default ‘’,
`w` int(8) NOT NULL default ‘0’,
`h` int(8) NOT NULL default ‘0’,
`alt` varchar(255) NOT NULL default ‘’,
`caption` text NOT NULL,
`date` datetime NOT NULL default ’0000-00-00 00:00:00’,
`author` varchar(255) NOT NULL default ‘’,
`thumbnail` int(2) NOT NULL default ‘0’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=2
</code></pre>
Last edited by KurtRaschke (2005-12-02 17:15:25)
kurt@kurtraschke.com
Offline
#21 2005-12-02 17:29:41
- Nonsense
- Member
- Registered: 2005-11-25
- Posts: 53
Re: Image upload problem.
ERROR:
You have an error in your SQL syntax near ‘ENGINE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=2’ at line 14
Offline
#22 2005-12-02 17:31:04
- Nonsense
- Member
- Registered: 2005-11-25
- Posts: 53
Re: Image upload problem.
Removed that line.
And it works!
Thanks.
Offline
Re: Image upload problem.
Glad to see you got it fixed. :)
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline