phpwcms Support Forum

This query populates the default ads format table:


INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(1, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1 ...

I found it in upgrade 1.3.2. Everything seems to be fine now.

In Upgrade 1.3.2 I found the glossary CREATE TABLE script ... I also found I had several other tables missing and added those. I think I'm okay now.

The only initial install I've done was with 1.1 ... it's all been upgrades since then.

Where can I find the include/inc_module/mod_glossary/setup.php file?

After upgrading from 1.2.5-DEV to 1.4.1 ... I get this error:
Warning: Invalid argument supplied for foreach() in /home/username/public_html/wcms/include/inc_module/mod_glossary/backend.listing.php on line 205
This is caused by a missing phpwcms_glossary table in the database. I looked in every ...

This is fixed ... dumb me. The first CREATE TABLE query has different fields ... data was inserted and then the table was altered to a new structure. So ... I ran a TRUNCATE TABLE and then ran the INSERT query again and it was successful.

This problem is corrected but the MODULE --> Glossary ...

I found where the phpwcms_country table was created: 07_27-08-2005_to_1.2.7.sql and since the table was empty, I recreated it. Then, in database upgrade 1.3.5 to 1.5, I ran the queries there and it ran successfully ... BUT ... while there is data in the INSERT statements, no data is in the table for ...

I ran the queries again, starting with 1.2.1, but the changes have already been made as I get a "duplicate column" error.

I checked with phpMyAdmin ... country table exists but is empty and contains the following fields:
country_id
country_updated
country_iso
country_iso3
country_isonum
country ...

I do not know if this is related or not ...

After logging in to the backend, I looked around ... in MODULES --> Glossary, this error was displayed:
Warning: Invalid argument supplied for foreach() in /home/username/public_html/wcms/include/inc_module/mod_glossary/backend.listing.php on line 205 ...

I am upgrading from 1.2.5-DEV to 1.4.1 ... and it has gone well. The site can be seen and it all appears normal. However ... the database updates had these errors when running the database upgrade for 1.3.5 to 1.5:
ERROR: Duplicate column name 'acat_archive' -> ALTER TABLE `phpwcms_articlecat` ADD ...

I adjusted some settings and it works great, by the way! Thank you for your work.

This looks messy. Is the CSS stylesheet included in the current download or do I have to figure out how to fix it?

I'm certain I have overlooked something. This new install of 1.3.0 is my first look at it ... and I like it, although some things are different, so I'm still figuring a few things out.

Here's the problem ... the backend site structure is normal. I have menu items and sub-menus, but I cannot make ...

I don't know if this is even possible. In the same way that {RANDOM} randomly selects and displays an image, is it possible to randomly select and display a block of text? I guess this would be semi-dynamic content.

I've put in a request to re-compile PHP with additional font and graphic library support. I'll let you know things work out.