Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Can't log in to old version of TXP. Upgrading?
Hey all,
I set up a website for my Dad back in 2004 using textpattern.(i can’t find the exact version number) It’s all worked very well since then though I’ve never really updated textpattern itself.
Recently however he’s not been able to log into the admin side of things. The site still works fine, and I tried resetting the password manually in the DB but I can’t log in at all. I’m suspecting that perhaps MySQL or PHP were upgraded by the hosting company that’s not entirely compatible with this version of textpattern.
Does that make any sense, or could it be something else. I was consdering just upgrading to the latest version, but perhaps that might cause a load of other problems.
Any sugestions?
Offline
Re: Can't log in to old version of TXP. Upgrading?
Hi kevin
Have did exactly what explained here ?
Becausse i haven’t heard that something has changed about loging code!
Sheers
Offline
Re: Can't log in to old version of TXP. Upgrading?
^^ that should work, but if it doesn’t
Create a backup of all the TXP database tables and the TXP program files (just in case, so you switch back to the current situation if needed)
Then install a fresh, up-to-date TXP version.
Offline
Re: Can't log in to old version of TXP. Upgrading?
I did update the password manually via MySQL using the method suggested above and that did not work.
I’m a little confused about why that would be.
Has the DB structure changed in the newer versions, or will the update cause trouble?
Offline
Re: Can't log in to old version of TXP. Upgrading?
2004 is a long time ago. Upgrading is highly recommended for security reasons. The first official TXP release was in 2005, so you have one of the 1.x versions (alpha, beta, gamma or release candidate). Upgrading should work, but may need some manual adjustments.
Offline
Re: Can't log in to old version of TXP. Upgrading?
Ok guys, I’ve tried upgrading but getting the following errors in the login page now. I don’t know why the upgrade didn’t kick in & I still can’t log in.
Warning: Table ‘sheela.txp_lang’ doesn’t exist select name, data from txp_lang where lang=‘english’ in /storage/webtree/vhosts/www.irelands-sheelanagigs.org/textpattern/lib/txplib_db.php on line 82
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /storage/webtree/vhosts/www.irelands-sheelanagigs.org/textpattern/lib/txplib_misc.php on line 177
Warning: Table ‘sheela.txp_lang’ doesn’t exist select name, data from txp_lang where lang=‘en-gb’ in /storage/webtree/vhosts/www.irelands-sheelanagigs.org/textpattern/lib/txplib_db.php on line 82
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /storage/webtree/vhosts/www.irelands-sheelanagigs.org/textpattern/lib/txplib_misc.php on line 177
I’m very out of practice with textpattern so if anyone has any idea what those problems are let me know. I followed the upgrade instructions and replace the textpattern directory except for the config.php. It also mentioned an rpc/ directory, but I don’t see that anywhere. I upgraded the main index.php and now the site isn’t working correctly as I get a separate error. I think it’s a problem with my templates, but I’m unsure how to edit them.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /storage/webtree/vhosts/www.irelands-sheelanagigs.org/textpattern/lib/txplib_misc.php on line 177
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /storage/webtree/vhosts/www.irelands-sheelanagigs.org/textpattern/lib/txplib_misc.php on line 177
Tag error: <txp:sitename /> -> Textpattern Notice: tag is deprecated on line 1098
Any ideas? I really wanna fix this for my dad cause it’s a big problem so I’d appreciate any pointers at all.
Thanks a lot!
Last edited by kevin (2009-02-07 14:06:49)
Offline
Re: Can't log in to old version of TXP. Upgrading?
You’ll have to re-create the missing txp_lang table, which has the following table layout:
`id` int(9) NOT NULL auto_increment,
`lang` varchar(16) NOT NULL,
`name` varchar(64) NOT NULL,
`event` varchar(64) NOT NULL,
`data` tinytext,
`lastmod` timestamp,
PRIMARY KEY (`id`),
UNIQUE KEY `lang` (`lang`,`name`),
KEY `lang_2` (`lang`,`event`)Another way to do that would be to install TXP somewhere else, backup the txp_lang table and restore it to the TXP install that is missing it.
Offline
Re: Can't log in to old version of TXP. Upgrading?
Thanks – that’s solved a good chunk of the errors. I’m still getting the ‘tag is deprecated’ error and I cna’t log in to change the templates. Can I change them manually in the DB or the filesystem?
Also, if there’s anyone out there who can help me with this, I’ll happily trade you some free web design, or flash work in exchange fore helping me with this. :) (I’m not too bad, www.kevin.ie)
Offline
#9 2009-02-17 17:01:46
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Can't log in to old version of TXP. Upgrading?
kevin wrote:
I’m still getting the ‘tag is deprecated’ error
Change <txp:sitename /> (in the page template) to <txp:site_name />.
Edit: oh sorry, you can’t login…
Have you tried to set up a fresh install (in a subdirectory), export the old database and import it into the new install, and if everythings works there move it back to the root?
Last edited by els (2009-02-17 17:07:16)
Offline
Re: Can't log in to old version of TXP. Upgrading?
Els – thanks for the reply. I searched the forums some more and figured out I could edit the database directly, and so was able to fix the problem there. Still can’t login though and the site isn’t working at all sadly. :(
I think I’ll try your suggestion of reinstalling the whole thing and see how. Thanks!
Offline
Re: Can't log in to old version of TXP. Upgrading?
Still can’t login though
Haye you tried resetting the admin password manually?
Another thing to try: have you got another install on that server or an equivalent server with an identical setup? If so, you can log into phpmyadmin, go into the txp_users table and find that user. Edit the user (pencil symbol) and copy the password field. Now log into phpmyadmin for your faulty site, go into txp_users and your faulty user and paste in the password field and save. try logging in with the transferred pass. That’s worked for me when the other method didn’t. Alternatively export the entire working user (just the user entry not the entire table) as sql, copy the INSERT SQL and import that into txp_users table in the faulty txp setup.
TXP Builders – finely-crafted code, design and txp
Offline
Re: Can't log in to old version of TXP. Upgrading?
jakob – cheers for the help. I’ve tried resetting the password various different ways, via the software, directly via mysql etc… No joy.
Honestly, at this stage I think there’s something larger going on, so I think I’ll backup everything and try a clean reinstall. If that doesn’t solve it, then something more drastic will need to be done. :(
Offline