Login problems after upgrade

Get help with installation and running phpwcms here. Please do not post bug reports or feature requests here.
Kvist
Posts: 87
Joined: Sat 30. Oct 2004, 04:19
Location: Denmark
Contact:

Login problems after upgrade

Post by Kvist »

I am SO frustrated with this stupid problem!!! :evil:

I've been through all posts related to login problems, but I still haven't found a solution.

I just upgraded from RC4 to 1.2.1-DEV which all went OK. Then when I tried to login, it just kept refreshing the login page. No errors or anything. I've checked and doubble checked my paths and they all seem correct to me.

I also have a lot of errors on my page (http://www.kvistnet.dk) but I think that I can fix them as soon as I get into the admin area.

Would someone be so kind as to help me with a solution before I rip out the rest of my hair and throw a fit on the floor?

Code: Select all

<?php

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

// site values
$phpwcms["site"]              = "http://www.kvistnet.dk/";
$phpwcms["admin_email"]       = "kvist@kvistnet.dk";

// 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"]      = 2097152; //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"]   = 400; //max height of the large preview image
$phpwcms["max_time"]          = 1800000; //logout after max_time/60 seconds

// other stuff
$phpwcms["compress_page"]     = 0; //0 = OFF, 1-9: page compression ON (1 = low level, 9 = highest level)
$phpwcms["imagick"]           = 0; //0 = GD,  1 = ImageMagick, 2 = ImageMagick 4.2.9
$phpwcms["imagick_path"]      = ""; //Path to ImageMagick (default="" - none)
$phpwcms["use_gd2"]           = 1; //0 = GD1, 1 = GD2
$phpwcms["rewrite_url"]       = 0;  //whether URL should be rewritable
$phpwcms["wysiwyg_editor"]    = 1;  //0 = no wysiwyg editor, 1 = HTMLarea, 2 = FCKeditor, 3 = browser based
$phpwcms["phpmyadmin"]        = 0;  //enable/disable phpMyAdmin in Backend
$phpwcms["default_lang"]      = "en";  //default language
$phpwcms["charset"]           = "iso-8859-1";  //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_timeout"]     = 14400;  //default cache timeout setting in seconds - 0 = caching Off

// 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']   = 'kvist@kvistnet.dk'; // reply/from email address
$phpwcms['SMTP_FROM_NAME']    = 'Jens Kristian Kvist'; // reply/from name
$phpwcms['SMTP_HOST']         = 'localhost'; // SMTP server (host/IP)
$phpwcms['SMTP_PORT']         = 25; // SMTP-Server port (default 25)
$phpwcms['SMTP_MAILER']       = 'mail'; // default phpMailer: smtp, mail (default), sendmail
$phpwcms['SMTP_AUTH']         = 0; // sets SMTP_AUTH to ON/OFF
$phpwcms['SMTP_USER']         = ''; // default SMTP login (user) name
$phpwcms['SMTP_PASS']         = ''; // default SMTP password


// 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']     = '/customers/kvistnet.dk/kvistnet.dk/httpd.www';


?>
NB: I'll be forever grateful!
PS: Answers in German are OK too.
User avatar
pico
Posts: 2595
Joined: Wed 28. Jul 2004, 18:04
Location: Frankfurt/M Germany
Contact:

Post by pico »

Hi

did you run all Database Updates Step-by-Step from your old to the new Version.
Run ../setup/upgrade.php


Your conf.inc.php looks OK.

There are some new Settings in the Permissions also

Folder phpwcms_ftp 777
Folder phpwcms_filestorage 777
Verzeichnis content 777
Verzeichnis content/images 777
Verzeichnis content/gt 777
Verzeichnis content/form 777
Verzeichnis content/rss 777
Verzeichnis content/tmp 777
Verzeichnis content/pages 777

File setup/setup.conf.inc.php 666
File phpwcms_template/inc_css/frontend.css 666
File config/phpwcms/conf.indexpage.inc.php 666
File phpwcms_template/inc_default/startup.php 666
Lieber Gott gib mir Geduld - ABER BEEIL DICH
Horst - find me at Musiker-Board
Kvist
Posts: 87
Joined: Sat 30. Oct 2004, 04:19
Location: Denmark
Contact:

Post by Kvist »

Grüß dich Horst!

I ran the upgrade.php and updated my database from the latest RC4 to 1.1.9 and then from 1.1.9 to 1.2.1.

All rights are as you've described in your answer.

If you're a guru in phpwcms and/or mysql and PHP I'd love it if you would take a look at my installation. I am clueless...

Thanks!
User avatar
hjb
Posts: 39
Joined: Tue 6. Apr 2004, 13:41
Location: Hamburg/Germany
Contact:

error search

Post by hjb »

Hi,

have you checked your phpinfo yet? If so start from sratch on and install again, otherwise you will be left bolded.

kind regards

Achim
Man sieht sich immer zweimal im Leben....
Kvist
Posts: 87
Joined: Sat 30. Oct 2004, 04:19
Location: Denmark
Contact:

Post by Kvist »

Hi Achim!

I already tried to install it all over again - but do you mean delete all of my existing files and then install from scratch? That would really make me bald, 'cause I have so many files and pages that I've worked on for the last year, that it would be nothing less than a catastrophe to loose them.

There MUST be another solution...? :(
User avatar
hjb
Posts: 39
Joined: Tue 6. Apr 2004, 13:41
Location: Hamburg/Germany
Contact:

Start again....

Post by hjb »

Hi kvist,

just save the "important" pages. all other stuff will be hold in the database dump. Export by phpmyadmin (include all data). Or you start with a new local installation and import your original database content into the local installation from where the error search should be much easier. :shock: :lol:
Man sieht sich immer zweimal im Leben....
User avatar
pico
Posts: 2595
Joined: Wed 28. Jul 2004, 18:04
Location: Frankfurt/M Germany
Contact:

Post by pico »

Hi

I always do a Upgrade by this way

1. make a Backup of the whole Site and the Database
2. create a new Folder like /ver121
3. upload the new Version into this Folder
4. set Permissions in this Structure
5. start setup-Script and make a clean new Installation
6. use a db_prepend like 'cms121_' and let the script create new Tables
7. create a new Admin account
8. check and finnish the Setup
9. download the conf.inc.php - and upload it
10. login in the new Version and see that all is fine
11. edit the SQL-Dump so that the Tablenames look like cms121_phpwcms_article and so on
12. import this sql-Dump into the new Tables
13. copy all Content from old phpwcms_filestorage to the new
14. copy all other Files you need like picture
15. run upgrade.php to convert the filestorage - no SQL-Updates!
16. check that the new Site is working
17. if all works fine delete all old Folders
18. move the Structure from /ver121 to the old Place
19. edit the conf.inc.php (change the Path /ver121 to the right one)
20. thats it - be happy :D

18a. or leave it there and set the root in your Serverconfig to the new Folder - thats how I do it - goto step 20. :wink:

hope I missed nothing :lol:
Lieber Gott gib mir Geduld - ABER BEEIL DICH
Horst - find me at Musiker-Board
Kvist
Posts: 87
Joined: Sat 30. Oct 2004, 04:19
Location: Denmark
Contact:

OK

Post by Kvist »

OK, I guess I'll try it that way as soon as I get home from work tonight. I really hope it'll relieve me of my problems!

Thanks!

/Kvist
Kvist
Posts: 87
Joined: Sat 30. Oct 2004, 04:19
Location: Denmark
Contact:

Post by Kvist »

pico wrote: 11. edit the SQL-Dump so that the Tablenames look like cms121_phpwcms_article and so on
12. import this sql-Dump into the new Tables
I'm following your guide right now, but I have a question that you might be able to answer:
When I make an SQL-dump the file size is just above 7Mb but phpmyadmin only lets me upload files smaller than 2Mb. Is there a work around? Copy and paste in small bits takes a LOOONG time.

Thanks for your help so far!
User avatar
pico
Posts: 2595
Joined: Wed 28. Jul 2004, 18:04
Location: Frankfurt/M Germany
Contact:

Post by pico »

Hi

Ok I'm lazy and don't do the SQL-Dump - I use the "Copy Table to" Function in phpMyAdmin :wink:
Lieber Gott gib mir Geduld - ABER BEEIL DICH
Horst - find me at Musiker-Board
Kvist
Posts: 87
Joined: Sat 30. Oct 2004, 04:19
Location: Denmark
Contact:

Success - almost...

Post by Kvist »

Yup, it's almost running like it did before, BUT there are still a few errors.

1. In the file manager I get the following error:

Code: Select all

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 6400 bytes) in /customers/kvistnet.dk/kvistnet.dk/httpd.www/include/inc_ext/ss_image/ss_image.class.php on line 84
Ï think this is also the reason behind the next error:

2. In the article listing, the template is somehow ignored. The pictures aren't shown eventhough I am using a modified sample.tmpl in all articles. How can that be?

3. The file browser gives me an internal server error.

4. In the main part of all articles I can't change the text because of the new editor. While loading it shows me the text, but as soon as the script has loaded, the text disappears.

That's what I've gotten so far. Are these general problems or can I solve them by simply editing something?
shildebr
Posts: 24
Joined: Mon 18. Oct 2004, 09:49
Contact:

Post by shildebr »

Hiho,
pico wrote: 20. thats it - be happy :D
i follow your description, but i get this error when i make the filstorage-update:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/ja2/03/456/00000013/htdocs/thwcms/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 /mnt/ja2/03/456/00000013/htdocs/thwcms/setup/upgrade_filestorage.php on line 45
Where is the failure?
Bye
Sven
User avatar
pico
Posts: 2595
Joined: Wed 28. Jul 2004, 18:04
Location: Frankfurt/M Germany
Contact:

Post by pico »

Hi

please check wich mySQL Version is running at your Server.

Admin->phpinfo

is it is < 4.0.2 then this is maybe the Problem.
Lieber Gott gib mir Geduld - ABER BEEIL DICH
Horst - find me at Musiker-Board
shildebr
Posts: 24
Joined: Mon 18. Oct 2004, 09:49
Contact:

Post by shildebr »

Hallo.
pico wrote:is it is < 4.0.2 then this is maybe the Problem.
its running Version
Client API version 4.0.20
.
I must say, my provider is Strato :(
Bye
Sven
User avatar
pico
Posts: 2595
Joined: Wed 28. Jul 2004, 18:04
Location: Frankfurt/M Germany
Contact:

Post by pico »

Hi

I don't understand nothing anymore :cry:

try to turn the Persistance Off in conf.inc.php

Code: Select all

$phpwcms["db_pers"]           =0;
Lieber Gott gib mir Geduld - ABER BEEIL DICH
Horst - find me at Musiker-Board
Post Reply