phpwcms Support Forum

Setting this variable to a more meaningful value indeed helped. Thanks.

I'm trying to move my current installation of phpwcms to a new server.
I've already copied all the files and the database.

However, there seems to be a problem with the value of PHPWCMS_ROOT as I get the following error:


Warning: include_once(/var/www/html/include/inc_front/content.article.inc ...

ourpobox wrote:Hello Pieter,

Have you upgraded and not had this error since your last post? I just did a fresh install of 1.2.6 and I am having the very same errors you mentioned! Any clues?

Thanks

Greg

No, I'm still running 1.1.

A quick update. I reverted to 1.1RC4 (was not as difficult as I expected) and now everything works fine again.
Very strange. Did anything change in the code for contacting the database that might cause trouble?

if you had such problems i would please you to contact your host maybe they have an problem with the server.
I agree. It almost seems like there is a 'security' policy in place that allows me to do UPDATE and SELECT, but not INSERT. Strange thing is that there are no problems whatsoever when using ...

had a same Problem one time - some Files was not overwritten by the new Version. So my clue was to delete all *.php Files and upload them all again.
Sorry for my late reaction but I did not have much spare time.

Anyway, thanks for you answer but this (i.e. uploading all files again) doesn't solve ...

I've tried to run the same query as above from within phpMyAdmin.
This doesn't pose any problems. This getting stranger by the minute. Does anyone have a clue why I can run the query from phpMyAdmin, but phpWCMS fails?

and the config.php settings are correct?
Well, I cannot be sure of course, but I haven't changed anything after the upgrade.

it looks like you DON NOT execute ALL database upgrades!
I thought of that, but the schema from my database looks pretty much the same as the script for 1.2.5-DEV. The ...

frold wrote:did yuo run the database updates?

Of course I did

I recently upgraded my 1.1RC4 release to 1.2.5-DEV. Everything seemed to work fine, until I tried to add a new article. This resulted in the following error:


error while connecting to database:
INSERT INTO phpwcms_article (article_cid, article_uid, article_username, article_title, article_keyword ...

Well, actually the title says it all.
When I update my current version (22-06-2004), how should I proceed? Should I just upload all files and thus overwrite old versions by new ones or is there a better way?
Also, I noticed that in this case there are no notable changes in the database, but what if ...

I think I have found the problem
I've run out of disk space at my hosting provider. Maybe that causes the problem with the MySQL database. Is that possible?

I already did that. It did not help

When I run the setup script, there is some problem with creating the tables:
Please proof your database settings. There might be some mistakes!

However, 9 tables have created ?!
These are phpwcms_article, phpwcms_articlecat, phpwcms_articlecontent, phpwcms_bid , phpwcms_blog, phpwcms_chat ...

Pappnase wrote:hello

maybe you have to decrease the width of the main table!? if you mean these white spaces.

Well, reducing the width will probably not help if the height (between title and image that is) is an issue .