Textpattern CMS

#1 2006-09-07 14:09:46

vesam

New Member

Registered: 2005-08-14

Posts: 4

New articles do not get IDs assigned

Hi,

Recently the site being run on textpattern was moved from previously well working unix/apache server to server running IIS.

There was a few problems related to international characters etc. but they got eventually fixed.

Now as it came to posting new articles it turned out that the articles do not get ID assigned to them when posted. In the link in the artickle list the id is set to =0 (and thus it is possible to delete and review it), viewing database trough db_manager plugin however shows that the article has blank space in the place of ID. When posting the first symptom is that URL-only title is not loaded to its textfield.

Upon re-opening the article from the article list the content disappears and posted date & date&time boxes yield a warning:

<code>
Warning: date(): Windows does not support dates prior to midnight (00:00:00), January 1, 1970 in
D:\www\www.desigence.fi\textpattern\include\txp_article.php on line 632
</code>

If I give the article an ID manually with db_tools plugin (next vacant ID number) the article gets fixed.

Now, its nice that this can be fixed manually, but I would really not like to do this for all of the future articles.

I guess same applies to images as well (new ones can’t be added).

Selected details from the diagnostics are:

<code>
Textpattern version: 4.0.3 (r1188)
last_update: 2006-03-10 13:26:00/2006-03-10 11:21:00
Document root:
$path_to_site: …
Textpattern path:…
Permanent link mode: messy
upload_tmp_dir: C:\PHP\uploadtemp
Temporary directory path:…
Site URL: …
PHP version: 4.3.3
Register globals: 1
server_time: 2006-09-07 17:04:11
MySQL: 4.0.18-nt
Locale: en_GB.UTF-8
Server: Microsoft-IIS/5.0
php_sapi_mode: cgi-fcgi
os_version: Windows NT 5.0

Pre-flight check:
————————————
Your version of PHP has security related risks. Please turn register_globals off or update to a newer PHP version.
————————————

.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

————————————
</code>

If I would have a say we would have not moved from the old server in 1st place. Any idea of the fix (or cause) on this IIS?

#2 2006-09-07 14:15:23

Sencer

Archived Developer

From: cgn, de

Registered: 2004-03-23

Posts: 1,803

Website

Re: New articles do not get IDs assigned

Sounds like this mysql-bug/issue:
http://forum.textpattern.com/viewtopic.php?id=18382

#3 2006-09-07 21:41:29

vesam

New Member

Registered: 2005-08-14

Posts: 4

Re: New articles do not get IDs assigned

Thanks,

I managed to upload PhpMyAdmin and fixed the auto increments.

Now another problem presists.

The image tab presists on redirecting me to <code>?event=image&step=image_edit&id=0</code> instead of just <code>?event=image</code>.

That must be because of trying to upload a new image back when there was bug with auto incrementing tables, and the txp looks like it still wants to take me to finish the uploading.

But where is that redirect sored to? Not in to a cookie since the redirect is same with every browser and computer, and I have not found it from data base either…