Site Structure Error

Please post all install related problems here. Visit this forum first for troubleshooting.
Post Reply
miershpedankl
Posts: 39
Joined: Wed 8. Mar 2006, 13:19
Location: East Coast, USA
Contact:

Site Structure Error

Post by miershpedankl »

Please help if you can. :D Since I upgraded to v 1.2.7 I have not been able to make changes to my Site Structure. I get a page that simply says "error" and the address reads: "http://the-lee-family.us/include/inc_ac ... ucture.php"

Can someone tell me what I need to do to fix this problem?

Thanks a ton!
miershpedankl
If you don't let ANYTHING happen to someone, then NOTHING will happen to them.
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Post by flip-flop »

Hi miershpedankl,

please post the whole error message.
What version was running before the update?

Knut
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
miershpedankl
Posts: 39
Joined: Wed 8. Mar 2006, 13:19
Location: East Coast, USA
Contact:

Post by miershpedankl »

That is actually the whole error message. It just says "error" at the top left of the screen.

Before the update I want to say that I was running 1.2.4, but I could be wrong. Would it help to post the content of /include/inc_act/act_structure.php??

Thanks for your help,
miershpedankl
If you don't let ANYTHING happen to someone, then NOTHING will happen to them.
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Post by flip-flop »

Have you do so during the update of your db?:

12__1.2.4-DEV_to_1.2.5-DEV.sql
13__1.2.5-DEV_to_1.2.6-DEV.sql
14__1.2.6-DEV_to_1.2.7-DEV.sql

And have you compare the old and new conf.inc.php?
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
miershpedankl
Posts: 39
Joined: Wed 8. Mar 2006, 13:19
Location: East Coast, USA
Contact:

Post by miershpedankl »

Come to think of it, I was having problems with my new conf.inc.php and my site was down for a few days. But I was not able to figure out what the problem was. I may have the old conf.inc.php rather than the new one. Could this cause this problem?

As far as my db goes, I am not sure if it was updated correctly. Honestly, I'm not sure what you mean by
Have you do so during the update of your db?:

12__1.2.4-DEV_to_1.2.5-DEV.sql
13__1.2.5-DEV_to_1.2.6-DEV.sql
14__1.2.6-DEV_to_1.2.7-DEV.sql
Is that how my db should have updated? :oops:

thanks,
miershpedankl
If you don't let ANYTHING happen to someone, then NOTHING will happen to them.
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Post by flip-flop »

First: Please compress the two pictures at the first site. (2 x 620KB).

Have you do the update like this? http://www.phpwcms-docu.de/update_1.x.x_en.phtml

A new version can´t running stabil with an old config.
You must use the new one.
Please compare the old and new one and fill up missing entries to the new config.

Her we have a standard conf.inc.php
If you did running your site at a "normal" provider, please fill up:
---------------------
// database values
- $phpwcms["db_user"]
- $phpwcms["db_pass"]
- $phpwcms["db_table"]
.
// site values
- $phpwcms["admin_email"]

// smtp values
- $phpwcms['SMTP_FROM_EMAIL']
- $phpwcms['SMTP_FROM_NAME']
---------------------
Thats all. Make a test please

Code: Select all

// phpwcms base values -> needed in any document

// database values
$phpwcms["db_host"]           = "localhost";
$phpwcms["db_user"]           = "db_user";
$phpwcms["db_pass"]           = "db_pass";
$phpwcms["db_table"]          = "db_table";
$phpwcms["db_prepend"]        = "";
$phpwcms["db_pers"]           = 1;

// site values
$phpwcms["site"]              = "http://".$_SERVER['SERVER_NAME']."/";
$phpwcms["admin_email"]       = "webmaster@mydomain.tld";

// paths
$phpwcms["DOC_ROOT"]          = $_SERVER['DOCUMENT_ROOT'];
$phpwcms["root"]         		= "";         //default: ""
$phpwcms["file_path"]         = "phpwcms_filestorage";    //default: "phpwcms_filestorage"
$phpwcms["templates"]         = "phpwcms_template";    //default: "phpwcms_template"
$phpwcms["content_path"]      = "content"; //default: "content"
$phpwcms["cimage_path"]       = "images";  //default: "images"
$phpwcms["ftp_path"]          = "phpwcms_ftp";     //default: "phpwcms_ftp"
// content values
$phpwcms["file_maxsize"]      = 52428800; //Bytes (50 x 1024 x 1024)
$phpwcms["content_width"]     = 538;      //max width of the article content column - important for rendering multi column images
$phpwcms["img_list_width"]    = 100;      //max with of the list thumbnail image
$phpwcms["img_list_height"]   = 75;       //max height of the list thumbnail image
$phpwcms["img_prev_width"]    = 538;      //max width of the large preview image
$phpwcms["img_prev_height"]   = 538;      //max height of the large preview image
$phpwcms["max_time"]          = 1800;     //nach wieviel Sekunden soll automatischer logout erfolgen? 1800 Sekunden=30Minuten

// other stuff
$phpwcms["compress_page"]     = 3;        //wenn 1 = Seite komprimieren, 0 = Kompresion aus
$phpwcms["imagick"]           = 0;        //if 0 = GD, 1 = ImageMagick convert, 2 = ImageMagick 4.2.9
$phpwcms["imagick_path"]      = "";       //Path to ImageMagick
$phpwcms["use_gd2"]           = 1;        //if 0 = GD1, 1 = GD2
$phpwcms["rewrite_url"]       = 0;        //whether URL should be rewritable
$phpwcms["wysiwyg_editor"]    = 2;        //0 = no wysiwyg editor, 2 = FCKeditor, 4 = spaw
$phpwcms["phpmyadmin"]        = 0;        //enable/disable phpmyadmin in Admin section
$phpwcms["default_lang"]      = "en";     //default language
$phpwcms["charset"]           = "UTF-8";       //default charset "iso-8859-1"
$phpwcms["allow_remote_URL"]  = 0;        //0 = no remote URL in {PHP:...} replacement tag allowed, 1 = allowed
$phpwcms["gt_mod"]            = 0;        //0 = Graphical Text MOD disabled, 1 = enabled
$phpwcms["jpg_quality"]       = 75;		  //JPG Quality Range 25-100
$phpwcms["sharpen_level"]     = 1;        //Sharpen Level - only ImageMagick: 0, 1, 2, 3, 4, 5 -- 0 = no, 5 = extra sharp
$phpwcms["allow_ext_init"]    = 1;        //allow including of custom external scripts at frontend initialization
$phpwcms["allow_ext_render"]  = 1;        //allow including of custom external scripts at frontend rendering
$phpwcms["cache_enabled"]     = 0;        //cache On/Off - 1 = caching On / 0 = caching Off (default)
$phpwcms["cache_timeout"]     = 14400;    //default cache timeout setting in seconds - 0 = caching Off
//$phpwcms["tidy"]              = 1;        //use tidy to cleanup rendered document
//$phpwcms["tidy_command"]      = 'C:/Programme/AppServ/tidy/Tidy.exe -cqm -utf8 -asxhtml';        //use tidy to cleanup rendered document
$phpwcms["imgext_disabled"]   = ""; //comma seperated list of imagetypes which should not be handled "pdf,ps"
$phpwcms["multimedia_ext"]    = "aif,aiff,mov,movie,mp3,mpeg,mpeg4,mpeg2,wav,swf,swc,ram,ra,wma,wmv,avi,au,midi,moov,rm,rpm,mid,midi"; //comma seperated list of file extensiosn allowed for multimedia
$phpwcms["recipient_count"]   = 0;
$phpwcms["inline_download"]   = 1; //try to open download document in browser window
$phpwcms["form_tracking"]     = 1; //make a db entry for each form
$phpwcms["formmailer_set"]    = array('allow_send_copy' => 0, 'global_recipient_email' => 'form@localhost'); //for better security handling
$phpwcms["allow_cntPHP_rt"]   = 0; //allow PHP replacement tags and includes in content parts
$phpwcms["GETparameterName"]  = 'id'; //must have a minimum of 2 chars 

// dynamic ssl encryption engine
$phpwcms["site_ssl_mode"] 	  = "0"; // tuns the SSL Support of WCMS on(1) or off (0) DEFAULT '0'
$phpwcms["site_ssl_url"] 	  = ""; //URL assigned to the SSL Certificate. DON'T add a slash at the End! Exp. "https://www.yourdomainhere.tld"
$phpwcms["site_ssl_port"] 	  = "443"; //The Port on which you SSL Service serve the secure Sites. Servers DEFAULT is '443'

// smtp values
$phpwcms['SMTP_FROM_EMAIL']   = 'webmaster@mydomain.tld';
$phpwcms['SMTP_FROM_NAME']    = 'Webmaster';
$phpwcms['SMTP_HOST']         = 'localhost';
$phpwcms['SMTP_PORT']         = 25;
$phpwcms['SMTP_MAILER']       = 'mail';
$phpwcms['SMTP_AUTH']         = 0;
$phpwcms['SMTP_USER']         = 'user';
$phpwcms['SMTP_PASS']         = 'pass';

// Try to check and uncomment the DOCUMENT_ROOT if you have problems 
// often neccessary on IIS or default MacOS X webserver settings.
// Do not use backslash "\" on Windows - always replace "\" by "/" 
//$_SERVER['DOCUMENT_ROOT']     = '/home/www';

?>
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
miershpedankl
Posts: 39
Joined: Wed 8. Mar 2006, 13:19
Location: East Coast, USA
Contact:

Post by miershpedankl »

1. Ok - my config.inc file is up to date, but I am still not able to make changes to my site structure. :( Maybe a db issue. I remember everything in the update process up until the db part below. I don't remember that part...
5. Execute SQL-Update
upgrade_1_2_1_aa.png

Please klick the drop down field "select sql file".

You will see the following choices:

00__phpwcms_update_older.sql
01__phpwcms_1.1-RC4_22-04-2004.sql
02__phpwcms_1.1-RC4_31-05-2004.sql
03__phpwcms_1.1-RC4_08-06-2004.sql
04__phpwcms_1.1-RC4_13-08-004.sql
05__phpwcms_1.1-RC4_25-08-004.sql
06__phpwcms_1.1-RC4_15-10-004.sql
07__1.1.5-DEV_to_1.1.9-DEV.sql
07__27-08-2004_to_1.1.9-DEV.sql
08__1.1.9-DEV_to_1.2-DEV.sql
09__1.2.1-DEV_to_1.2.2-DEV.sql
10__1.2.2-DEV_to_1.2.3-DEV.sql
11__1.2.3-DEV_to_1.2.4-DEV.sql
12__1.2.4-DEV_to_1.2.5-DEV.sql

Please choose from this list the first date after the release that you have installed.
2. I did resize the pics, thanks for the heads-up!

3. I see there is a new release, so would it help for me to just go ahead with an update and make the db changes in the process? I'll just try not to break anything in the process. :)

Thanks again flip-flop!!

Miershpedankl
If you don't let ANYTHING happen to someone, then NOTHING will happen to them.
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Post by flip-flop »

He he, the pics are alway oversized. (2x320KB)

Please don´t setup to 1.2.8. The 1.2.7 must run. After this do the update to 1.2.8

OK: My suggestion:

first important thing: $phpwcms['cache_enabled'] = 0; :!: :!:

1. Make an backup of your db.
2. Kill all tables of the db
3. Restore the old db.
4. Search for any hint to the old version you have used. I hope it wasn´t 1.1RCxxx
- Look into your old db via phpMyAdmin and look into the folder /setup/update_sql/
There are some update files. Compare the part CREATE_TABLE with the tables in phpMyAdmin.
Thats one way to find out your old Version.
5. Run the db-setup again /setup/update_sql/upgrade.php

I hope it will solve your problem.
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
miershpedankl
Posts: 39
Joined: Wed 8. Mar 2006, 13:19
Location: East Coast, USA
Contact:

Post by miershpedankl »

Well I only started using WCMS this past Spring, so I am guessing that I didnt't have 1.1RCxxx loaded. I am pretty sure is was a more recent version that I got straight from the phpwcms site.

As far as the db goes -- sounds scary. I don't see the /setup/update_sql/ folder in phpMyAdmin, but I have the file I used to update my site. I cannot tell what version I updated from, but like I said, I am pretty sure it was 1.2.4.

Should I reinstall 1.2.7? Would that take care of things? One other thing I remember... when I was doing the update I was in a hurry and chose to "install" rather than "update." I thought that I was going to have to start over from scratch, but my site is still working. I guess... what do I need to do to start fresh, but not lose my site??

Thanks a ton flip-flop!! I'm not too fast at this stuff, so you help is much appreciated. :)

miershpedankl
If you don't let ANYTHING happen to someone, then NOTHING will happen to them.
User avatar
Oliver Georgi
Site Admin
Posts: 9919
Joined: Fri 3. Oct 2003, 22:22
Contact:

Post by Oliver Georgi »

1st backup your current database.

Then just open setup/upgrade.php in your webbrowser and select the each sql file - lets say starting at 11_.... If a query fails it will show an error - normally no problem. That's all.

Oliver
Oliver Georgi | phpwcms Developer | GitHub | LinkedIn | Систрон
miershpedankl
Posts: 39
Joined: Wed 8. Mar 2006, 13:19
Location: East Coast, USA
Contact:

Post by miershpedankl »

So I have tried all of the release upgrades, but I get an error for all of them. I started using wcms back in March, so my first version of it would have been a more recent one. Any suggestions?

Thanks again for your help!
miershpedankl
If you don't let ANYTHING happen to someone, then NOTHING will happen to them.
User avatar
Oliver Georgi
Site Admin
Posts: 9919
Joined: Fri 3. Oct 2003, 22:22
Contact:

Post by Oliver Georgi »

Download this release:
http://www.phpwcms.de/forum/viewtopic.php?t=11933

and make a parallel installation - it have to work. Otherwise you are doing something wrong. And often it's hard to say what it is exactly.

Oliver
Oliver Georgi | phpwcms Developer | GitHub | LinkedIn | Систрон
miershpedankl
Posts: 39
Joined: Wed 8. Mar 2006, 13:19
Location: East Coast, USA
Contact:

Post by miershpedankl »

Thanks Oliver! Please fogive me -- when you say parallel installationg would that be installing the entire program into a subfolder or something like that?

Thanks!
miershpedankl
If you don't let ANYTHING happen to someone, then NOTHING will happen to them.
User avatar
Oliver Georgi
Site Admin
Posts: 9919
Joined: Fri 3. Oct 2003, 22:22
Contact:

Post by Oliver Georgi »

yes, make a new subfolder and install it there. Use another db prefix too.

Oliver
Oliver Georgi | phpwcms Developer | GitHub | LinkedIn | Систрон
Post Reply