phpwcms Support Forum

Hello,

when I call "upgrade_filestorage.php", I receive the following errors:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /pathtomyaccount/cms/setup/upgrade_filestorage.php on line 36

TOTAL: ENTRIES
=================================================================

If last line number is < click here



Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /pathtomyaccount/cms/setup/upgrade_filestorage.php on line 45

The other two "upgrade_*.php"-files work fine. And there was no error when I updated the DB.

I want to upgrade from 1.1-RC4_2004-08-27_A and I've tested the upgrade process in a PHP4 (4.3.10) and in a PHP5 (5.0.3) environment. All CHMODs where set as described on the page.

And so there is, of course, an error on the mainpage:

Parse error: parse error, unexpected $ in /pathtomyaccount/cms/include/inc_front/front.func.inc.php on line 2562

Any Idea???

upgrade to what? the dev-release?

I would not do that - it is far from done!

has nothing to do with far from - but I have described somewhere here in the forum:

The "old" database has to be upgraded manually!!! You can NOT start by doing the known way. There are a lot of db changes. Check old init and new init and you will see the difference. Can be better done directly.

Sorry. I'm working on implementing an automatic way.

Oliver

hi guys,

i´ve created an update-sql-file that fits my needs...
maybe it helps somebody..but i don´t know which version everybody using here so maybe error-messages could occur...

if errors are occuring you have to change the file to your needs...

here is my file working for me...
but without any guarantee for you!
the prefix "1st" must be changed if you using other prefix or no one...
and maybe you have to alter more fields as described here...
than you can looking in the new install-sql and add it to my file in the same direction as you see here...


ALTER TABLE `1st_phpwcms_article` ADD `article_cache` varchar(10) NOT NULL default '0';
ALTER TABLE `1st_phpwcms_article` ADD `article_nosearch` char(1) NOT NULL default '0';
ALTER TABLE `1st_phpwcms_articlecat` ADD `acat_cache` varchar(10) NOT NULL default '';
ALTER TABLE `1st_phpwcms_articlecat` ADD `acat_nosearch` char(1) NOT NULL default '';
ALTER TABLE `1st_phpwcms_articlecontent` ADD `acontent_form` mediumtext NOT NULL;



CREATE TABLE `1st_phpwcms_bid` (
`bid_id` int(11) NOT NULL auto_increment,
`bid_cid` int(11) NOT NULL default '0',
`bid_email` text NOT NULL,
`bid_hash` varchar(255) NOT NULL default '',
`bid_amount` float NOT NULL default '0',
`bid_created` timestamp(14) NOT NULL,
`bid_verified` int(1) NOT NULL default '0',
`bid_trashed` int(1) NOT NULL default '0',
`bid_vars` mediumblob NOT NULL,
PRIMARY KEY (`bid_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `1st_phpwcms_cache` (
`cache_id` int(11) NOT NULL auto_increment,
`cache_hash` varchar(50) NOT NULL default '',
`cache_cid` int(11) NOT NULL default '0',
`cache_aid` int(11) NOT NULL default '0',
`cache_timeout` varchar(20) NOT NULL default '0',
`cache_changed` int(14) default NULL,
`cache_use` int(1) NOT NULL default '0',
`cache_searchable` int(1) NOT NULL default '0',
`cache_content` longblob NOT NULL,
`cache_page` longtext NOT NULL,
PRIMARY KEY (`cache_id`),
KEY `cache_hash` (`cache_hash`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `1st_phpwcms_forum` (
`forum_id` int(11) NOT NULL auto_increment,
`forum_entry` tinyint(1) NOT NULL default '0',
`forum_cid` int(11) NOT NULL default '0',
`forum_pid` int(11) NOT NULL default '0',
`forum_uid` int(11) NOT NULL default '0',
`forum_title` text NOT NULL,
`forum_created` int(10) NOT NULL default '0',
`forum_changed` timestamp(14) NOT NULL,
`forum_status` int(1) NOT NULL default '0',
`forum_deleted` int(1) NOT NULL default '0',
`forum_text` mediumtext NOT NULL,
`forum_var` blob NOT NULL,
PRIMARY KEY (`forum_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `1st_phpwcms_map` (
`map_id` int(11) NOT NULL auto_increment,
`map_cid` int(11) NOT NULL default '0',
`map_x` int(5) NOT NULL default '0',
`map_y` int(5) NOT NULL default '0',
`map_title` text NOT NULL,
`map_zip` varchar(255) NOT NULL default '',
`map_city` text NOT NULL,
`map_deleted` int(1) NOT NULL default '0',
`map_entry` text NOT NULL,
`map_vars` text NOT NULL,
PRIMARY KEY (`map_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `1st_phpwcms_usergroup` (
`group_id` int(11) NOT NULL auto_increment,
`group_value` longblob NOT NULL,
PRIMARY KEY (`group_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

ATTENTION when naming tables:

"1st_phpwcms_article" -> default is phpwcms_article.

I will create such file today which you can place in "setup/update_sql" for execution then. If processed from there by using upgrade.php the correct table name "xxx_phpwcms_xxx" will be used for your install.

Oliver