Cannot Login!

Revolvermann · Post by **Revolvermann** » Fri 14. Jul 2006, 10:52

Hi there!

At first, I have now experience with phpwcms!

Since a few days, I cannot log into the admin-interface anymore. After entering username/password it just reloads the login.php without any errors.

After entering a false password, it tells me that the login was wrong.

I've read a few threads and in one of them they said something about session.use_trans_sid has to be 1.

However it seems to be off on our webspace.

Is that the source of the problem?

P.S.: It's an old version V1.1-RC2

Revolvermann · Post by **Revolvermann** » Fri 14. Jul 2006, 12:39

I forgot: The error appeared one week ago. Just out of nothing!

Revolvermann · Post by **Revolvermann** » Fri 14. Jul 2006, 15:13

I've been working on the problem for 5h now and i can't find a solution.

I emptied the whole userlog table and there are no new entrances created when i try to login.

I'd be happy if one of the more experienced users could help me.

ff123 · Post by **ff123** » Fri 14. Jul 2006, 16:29

Maybe this helps you?:
http://www.phpwcms.de/forum/viewtopic.p ... n&start=15
http://www.phpwcms.de/forum/viewtopic.p ... c&start=45
http://www.phpwcms.de/forum/viewtopic.p ... ight=login
http://www.phpwcms.de/forum/viewtopic.p ... ight=login
http://www.phpwcms.de/forum/viewtopic.p ... ight=login

Did you check the phpwcms requirements? Did anything change on your server (ask host). Did you try login with different browser or PC?

Regards, groeten,
vuurvos

Revolvermann · Post by **Revolvermann** » Fri 14. Jul 2006, 17:18

nope... none of the helped...

the page ist hostet an 1und1 (one of the biggest german hosts).
The problem is, that I'm unexperienced with this cms, so I spent the whole day with working out different solution-approaches, but none of them did the trick!

The page itself is working without problems. Can 1.1-RC4 Run on a mysql 5 system? Because this ist the actual used version for the database.

Is there a (easy) way to set up a phpwcms system with the newest version, and then porting all data, includuing the template to the new version?

Kosse · Post by **Kosse** » Fri 14. Jul 2006, 17:52

Revolvermann wrote:nope... none of the helped...

the page ist hostet an 1und1 (one of the biggest german hosts).
The problem is, that I'm unexperienced with this cms, so I spent the whole day with working out different solution-approaches, but none of them did the trick!

The page itself is working without problems. Can 1.1-RC4 Run on a mysql 5 system? Because this ist the actual used version for the database.

Is there a (easy) way to set up a phpwcms system with the newest version, and then porting all data, includuing the template to the new version?

Not sure it can run with mysql 5 ...
As for easy ~well, let's say that in half a day/one day you can port it, if the site is not too "hacked" in backend...
Use 1.2.7 and follow the many guidelines in forum to upgrade.
Cheers

Revolvermann · Post by **Revolvermann** » Wed 19. Jul 2006, 08:05

Okay, I uploaded the newest release, cloned the database and tried to upgrade.

I selected the _older.sql, because the current version ist a 1.1-RC2 (not a RC4, as i said before).

But all I get is ERRORS. I tried different sql-files. After opening the page, it just shows a blank page....

DeXXus · Post by **DeXXus** » Wed 19. Jul 2006, 11:41

Revolvermann wrote:Okay, I uploaded the newest release, cloned the database and tried to upgrade.

This is not going to work because the file storage scheme for images and such on those older versions worked differently and some locations for files changed, etc.

Revolvermann wrote:I selected the _older.sql, because the current version ist a 1.1-RC2 (not a RC4, as i said before).

When working with the "upgrade" process... -ALL- .SQL files should be run, in succession. (BTW, it can NEVER hurt to run them all - if some structures already exist... error messages will be the only harm.) and the UPGRADE FILESTORAGE process -must- be used for what I described above.

Revolvermann wrote:But all I get is ERRORS. I tried different sql-files. After opening the page, it just shows a blank page....

You really should clone your phpWCMS file structure -and- the database to a safe location (as a backup) and then just do an "in-place" upgrade. If you haven't added any/many hacks -or- addons... Just save/make note of those differences (including "conf.inc.php" settings, customized .CSS and the like). Then use FTP to overwrite your current installation with updated files from the latest archive, set the chmod permissions as always and proceed to browse at "/setup/upgrade.php". Run the script, UPGRADE FILESTORAGE, do all the .SQL files and then restore the customized .CSS, "config.inc.php" settings and any hacks/addons that are still compatible. WA LA!!

Sounds easier than it is, but really it's not that bad. If things still don't work... restore your "saved" phpWCMS file structure and database to original (that sounds easier than it is, too, sorry

)

Revolvermann · Post by **Revolvermann** » Wed 19. Jul 2006, 12:55

hm... okay... i tried it with all sql files.

Page just displays "Downloadsection"... and i cannot login with my amdin accounts....

DeXXus · Post by **DeXXus** » Wed 19. Jul 2006, 13:37

Revolvermann wrote:hm... okay... i tried it with all sql files.

Page just displays "Downloadsection"... and i cannot login with my amdin accounts....

Tried what? I hope you are not trying to just take a 1.1RC2 database from an SQL dump and restore it to a fresh install of 1.2.6 !

BTW, I ~believe~ there is a glitch with the 1.2.6 version that requires FTP upload in "binary" mode for files to be written correctly.

Revolvermann · Post by **Revolvermann** » Wed 19. Jul 2006, 13:43

i tried the upgrade with all sql files.

files are all uploaded in bin mode.

edit: result should be the same if i copied all the files on the ftp to a new dir, cloned the db and upgrade the copy... ? Because I cannot take the site down for the upgrade. Best solution would be if i was able to just redirect the domain to the new location.

DeXXus · Post by **DeXXus** » Wed 19. Jul 2006, 13:56

Revolvermann wrote:edit: result should be the same if i copied all the files on the ftp to a new dir, cloned the db and upgrade the copy... ?

Well, "conf.inc.php" changes, of course, too. Don't know how you're doing your "cloning"... but sometimes the thumbnails and file_storage, etc. doesn't just cooperate (ownership and permissions). And I'm not too sure about the feedback one gets from the UPGRADE_FILESTORAGE procedure, as far as what may not have "matched" to the database.

You should have all 38 of these:
(EDIT: Oops my install is pre1.2.7 version)

phpwcms_address
phpwcms_article
phpwcms_articlecat
phpwcms_articlecontent
phpwcms_bid
phpwcms_blog
phpwcms_cache
phpwcms_chat
phpwcms_country
phpwcms_file
phpwcms_filecat
phpwcms_filekey
phpwcms_fonts
phpwcms_fonts_colors
phpwcms_fonts_styles
phpwcms_formtracking
phpwcms_forum
phpwcms_guestbook
phpwcms_imgcache
phpwcms_keyword
phpwcms_log
phpwcms_map
phpwcms_message
phpwcms_module
phpwcms_newsletter
phpwcms_pagelayout
phpwcms_profession
phpwcms_results
phpwcms_resultscat
phpwcms_schedule
phpwcms_schedulecat
phpwcms_subscription
phpwcms_sysvalue
phpwcms_template
phpwcms_user
phpwcms_userdetail
phpwcms_usergroup
phpwcms_userlog

Revolvermann · Post by **Revolvermann** » Wed 19. Jul 2006, 14:12

okay... due to the fact, that i'm new to the company and i never had a chance to see the working installation in action, we decided to try a complete reinstallation.

I made a new, clean installation. How can I transfer the old template to the new system?

Edit: I copied the phpwcms_template table to my new installation, but when i try to access the new page http://www.mydomain.com/cms_new it redirects me to the old page (http://www.mydomain.com) ???

DeXXus · Post by **DeXXus** » Wed 19. Jul 2006, 18:44

My template_var field (type BLOB) of the phpwcms_template table contains URL references like that. I don't know of a way to edit those within the database.

I searched via phpMyAdmin for references to my site's URL and it showed two of my 16 templates had such references.

I then looked at them in the phpWCMS backend:
Admin-->Templates-->Template name

and found the section of the template that had the site URL "coded". That is where you would edit them. And that is only for that structure-type, of course. (I'm sure the phpwcms_cache table will also have them, others depend on whether URL "hard-coding" was entered into "content parts", etc.)

Revolvermann · Post by **Revolvermann** » Fri 21. Jul 2006, 08:56

Okay, i found a redirect in a *.js file, which was hardcoded into the template.

Anyway I'm still searching for the lines left and right of the content section. Does anyone know where they are defined?