phpwcms Support Forum

I recently update to 1.2.9 and have questions and error.

RSS:
First error is for RSS. When RSS load i get this error messages:

Code: Select all

Error, can NOT read file:  include/inc_ext/ConvertCharset/ConvertTables/utf8

Questions: What is that and how can i fix it?

Database:
Next error is this message below, updated work but confused about this error in database it may get me problems later.

Code: Select all

ERROR: 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 'CURRENT_TIMESTAMP' at line 1 -> ALTER TABLE `phpwcms_subscription` ADD `subscription_tstamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

Questions: What is that and how can i fix it?

New Folder:
Last thing is in 1.2.9 there is no folder "phpwcms_template" anymore, instead "template" as I understand. What I wonder about folder "template" seems not used after updated and it still use older folder "phpwcms_template".

Is that normal? I want use "template" of course because there is no folder "phpwcms_template" in 129 version anymore, but still seems used after upgrade for some reason. Is it normal?

About RSS is solved. For some reason it work now! Don’t now what problems was but after recently changed

Code: Select all

$phpwcms['charset']           = 'utf8';

to

Code: Select all

$phpwcms['charset']           = 'ISO-8859-1';

in conf.inc.php file or what I did, then it work.

Any idea or solutions for that database error and about that folder "template"?

Danke for all help

probably you still have

Code: Select all

// paths
$phpwcms['DOC_ROOT']          = $_SERVER['DOCUMENT_ROOT'];
$phpwcms['root']              = '';
$phpwcms['file_path']         = 'phpwcms_filestorage';
$phpwcms['templates']         = 'phpwcms_template';
$phpwcms['content_path']      = 'content';
$phpwcms['cimage_path']       = 'images';
$phpwcms['ftp_path']          = 'phpwcms_ftp';

in your /config/phpwcms/conf.inc.php?

change

Code: Select all

$phpwcms['templates']         = 'phpwcms_template';

to

Code: Select all

$phpwcms['templates']         = 'template';

and move all your old files from 'phpwcms_template' to 'template'.

Thanks SoulDiver,

That was the problem!

only problem is now that database error. Update seems work fine but it may cause trouble later and little worried about it. Don’t know what that error means and how to fix it, but hope someone know.

Here is the error message again:

Code: Select all

ERROR: 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 'CURRENT_TIMESTAMP' at line 1 -> ALTER TABLE `phpwcms_subscription` ADD `subscription_tstamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

Danke for all help

post deleted; posted in wrong topic!

read my post here regarding charsets:
http://www.phpwcms.de/forum/viewtopic.php?t=13890

Oliver

phpwcms Support Forum

Some questions after updated to 1.2.9

Some questions after updated to 1.2.9