Textpattern CMS

#16 2006-06-10 04:18:29

Smotchberry

Member

Registered: 2006-06-10

Posts: 20

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

hmm… let me check that out, i might have sent you the wrong combination.

#17 2006-06-10 04:23:31

Smotchberry

Member

Registered: 2006-06-10

Posts: 20

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

I just checked it out, that combination should be correct. I have also checked it out with another user name and password combination, same thing happens.

What does this mean?

Just in case it wasn’t clear, the same thing happens to me too – I don’t think it happened before, but i might be wrong.

Last edited by Smotchberry (2006-06-10 04:24:30)

#18 2006-06-10 04:41:10

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

Something may have happened to your database. Did your database software (MySQL) get upgraded recently?

Powweb supplies you with a database app of some kind, correct? Use it to take a look at your textpattern database, specifically the “txp_users” table.

You can try resetting the username and password through that. Do you have phpMyAdmin available to you?

#19 2006-06-10 04:48:08

Smotchberry

Member

Registered: 2006-06-10

Posts: 20

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

I think that they might have upgraded it when they moved to the new platform, but i am not sure. They do use phpMyAdmin version 2.8.0.1 – however I am a bit lost when it comes to using it, I will try to see if I can manage to reset the user name and password.

#20 2006-06-10 04:53:10

Smotchberry

Member

Registered: 2006-06-10

Posts: 20

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

What do I do here?

#21 2006-06-10 04:58:11

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

Okay, click on “Browse” at the top. Then you should see a list of all your users and their passwords (which have been “hashed” or one-way encrypted, they’ll look like nonsense letters and numbers).

First, are they all there? If so, try and reset one of them:

1. Click on the “edit” link for that user’s row.
2. Empty out the field for “pass” and enter in whatever password you want (it could be the same as before). Put it in all lowercase (because that’s what textpattern does already when it checks the password).
3. In the dropdown next to that field, choose “PASSWORD”.
4. Save your change, and try and login to the Txp admin again.

#22 2006-06-10 05:01:11

Smotchberry

Member

Registered: 2006-06-10

Posts: 20

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

IT WORKS! Jumps around estatically!

Now what?

#23 2006-06-10 05:04:29

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

Do the same for your other users. You don’t have to do it the same way if you don’t know their passwords, you can have their password reset from the “admin” tab.

Yep, your MySQL was updated. A little while ago MySQL changed how it hashes passwords, so basically making all old passwords incorrect.

Now that you can login, now you can post your diagnostic details. :)

#24 2006-06-10 05:06:13

Smotchberry

Member

Registered: 2006-06-10

Posts: 20

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

Here are the diagnositcs:

<i>Textpattern version: 4.0.1 (r888)
last_update: 2005-10-16 15:49:15/2005-10-16 13:06:53
Document root: /home/users/web/b461/pow.calheq/htdocs (/hermes/web03/b461/pow.calheq/htdocs)
$path_to_site: /hermes/web03/b461/pow.calheq/htdocs
Textpattern path: /home/users/web/b461/pow.calheq/htdocs/textpattern
Permanent link mode: section_id_title
upload_tmp_dir: /tmp
Temp folder: /www/t/thecompanyof/htdocs/textpattern/tmp
Site URL: thecompanyofextraordinary.com
TZ: US/Eastern
PHP version: 4.4.2
Register globals: 1
Magic quotes: 0/0
MySQL: 4.1.18-standard-log
Locale: en_GB.ISO_8859-1
Server: Apache

Pre-flight check:
————————————
File Upload Path is not writable: /www/t/thecompanyof/htdocs/files
Temp folder is not writable: /www/t/thecompanyof/htdocs/textpattern/tmp
————————————

.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/

<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [R,L]

RewriteRule ^(.*) index.php </IfModule> ————————————</i>

That’s awfully nice of MySQL doing that!

Last edited by Smotchberry (2006-06-10 05:08:22)

#25 2006-06-10 05:11:43

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

Two things I can see out of place (but unfortunately aren’t causing your problem): your file upload path and your tmp path.

Go to your prefs and then into advanced prefs. Empty out both the files and tmp folder path fields.

For files, enter in: /home/users/web/b461/pow.calheq/htdocs/files

and for tmp enter in: /home/users/web/b461/pow.calheq/htdocs/textpattern/tmp

What happens if you switch to messy urls, do your pages load properly then?

#26 2006-06-10 05:18:26

Smotchberry

Member

Registered: 2006-06-10

Posts: 20

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

No, while the diagnostics check has passed, the pages still don’t load properly. What do you think I should do?

#27 2006-06-10 05:20:31

Smotchberry

Member

Registered: 2006-06-10

Posts: 20

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

I just checked out the txp_section area in MySQL and an error message pops up saying:
`PRIMARY and INDEX keys should not both be set for column name`

Could this be the problem? If so, what should I do?

Updated: You can view a screenshot here.

Last edited by Smotchberry (2006-06-10 06:05:34)

#28 2006-06-10 06:49:04

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

The database warning can be ignored, it’s not causing your problem. :)

I should have clarified: with messy urls on you’d need to try and access your pages via messy urls, i.e: http://www.thecompanyofextraordinary.com/?s=services (which works).

So, your .htaccess needs to be tweaked somehow, it isn’t passing the info correctly.

Last edited by Mary (2006-06-10 06:49:58)

#29 2006-06-10 07:12:31

Smotchberry

Member

Registered: 2006-06-10

Posts: 20

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

Well it’s great that the pages can be accessed now – now I just need to figure out a way to sort out my .htaccess thing out. Do you think upgrading to the new version might be a good idea?

#30 2006-06-10 07:16:05

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Serious Issues Regarding TXP When Migrated to New Platfrom!

I don’t think it would make a difference, as far as urls are concerned. I’m not sure what you could try, some servers are really picky. You might try creating a new post in the How Do I? forum about it, perhaps someone else can offer some suggestions.