Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2006-07-24 07:31:59
- stebastian
- New Member
- Registered: 2005-07-29
- Posts: 6
TXP_Image ID Conflict: "there was a problem saving image data"
Hi,
I encountered a “there was a problem saving image data” error while trying to upload an images using the upload function located within the images tab.
I was attempting to upload a series of images. The first one seemingly uploaded without any problems. The succeeding attempts to upload images resulted in the error above. When I checked the image id of the only image i was able to upload, it was assigned id=0.
That led me to the conclusion that the problem is a result of a conflict on the numbering for the TXP_Image ID. the last image I uploaded should have been assigned an id of 21 instead of 0.
Just a side note, the site I’m working on was recently migrated to a different shared hosting account.
Anyone else encountered this problem before? Any help would be greatly appreciated.
Thanks!
Offline
#2 2006-07-24 14:53:25
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: TXP_Image ID Conflict: "there was a problem saving image data"
Hmm. Can you post your diagnostics, please?
Offline
Re: TXP_Image ID Conflict: "there was a problem saving image data"
Is the id field of the images table in your database still set as auto_increment? There have been reports of people who “lost” all autoincrement settings when they made mistakes when moving their database/restoring tables/otherwise mangled their db.
You can check for this when you go into phpmyadmin and look at the structure of the [PREFIX]txp_image table. To the right of id it should say auto_increment somewhere.
Offline
#4 2006-07-24 19:31:45
- stebastian
- New Member
- Registered: 2005-07-29
- Posts: 6
Re: TXP_Image ID Conflict: "there was a problem saving image data"
Mary wrote:
Hmm. Can you post your diagnostics, please?
Diagnostics:
Textpattern version: 4.0.3 (r1188)
last_update: 2006-02-15 07:25:09/2006-06-22 06:11:28
Document root: /home/content/p/a/t/pathways/html
$path_to_site: /home/content/p/a/t/pathways/html
Textpattern path: /home/content/p/a/t/pathways/html/textpattern
Permanent link mode: section_title
upload_tmp_dir: /tmp
Temp folder: /home/content/p/a/t/pathways/html/textpattern/tmp
Site URL: www.pathwaysphilippines.org
PHP version: 4.3.11
server_time: 2006-07-24 12:29:21
MySQL: 4.0.27-max-log
Locale: en_US.UTF-8
Server: Apache
php_sapi_mode: cgi-fcgi
os_version: Linux 2.4.21-32.ELsmp
.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
————————————
Offline
#5 2006-07-24 19:41:56
- stebastian
- New Member
- Registered: 2005-07-29
- Posts: 6
Re: TXP_Image ID Conflict: "there was a problem saving image data"
Hi Sencer,
You are correct. After migrating the site, the auto_increment attribute is no longer assigned to the id.
Sencer wrote:
Is the id field of the images table in your database still set as auto_increment? There have been reports of people who “lost” all autoincrement settings when they made mistakes when moving their database/restoring tables/otherwise mangled their db.
What’s the cause of this problem?
You can check for this when you go into phpmyadmin and look at the structure of the [PREFIX]txp_image table. To the right of id it should say auto_increment somewhere.
What other tables should I be double check to ensure that similar problems do not arise?
Offline
Re: TXP_Image ID Conflict: "there was a problem saving image data"
I guess this is connected to either how the backups are made or restored. I’ve never experienced this myself, so I don’t know the specific cause.
As for which other tables: There’s 9 instances of auto_increment in textpattern/setup/txpsql.php. You’ll find the specifics by looking into the file.
Offline