Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2019-08-29 15:15:53

mikeg
Member
From: Edmonton, Canada.
Registered: 2005-02-21
Posts: 31
Website

4.5.7 to 4.7.3 problem

Yet another upgrade problem. I am hoping some kind soul can help me. Recently tried to upgrade from 4.5.7 to 4.7.3 and got this in the admin screen upon login:

User_Error "Duplicate entry 'a85599dbb43a9c161c7e91d2cb40bcf4' for key 'PRIMARY'"
in /home/dirtpuppy/streetrag.com/textpattern/lib/txplib_db.php at line 410.
textpattern/lib/txplib_misc.php:1759 adminErrorHandler()
updateErrorHandler()
textpattern/lib/txplib_db.php:410 trigger_error()
textpattern/lib/txplib_db.php:545 safe_query()
textpattern/update/_to_4.6.0.php:158 safe_alter()
textpattern/update/_update.php:98 include()
textpattern/index.php:215 include()

Can anyone help me out? Any direction would be appreciated.

Last edited by mikeg (2019-08-29 15:24:30)


“I love Beethoven. Especially the poems.”
- Ringo Starr

Offline

#2 2019-08-29 15:57:52

jakob
Admin
From: Germany
Registered: 2005-01-20
Posts: 4,578
Website

Re: 4.5.7 to 4.7.3 problem

That looks like a comment nonce. Have a look at this thread for a similar report.

If you are familiar with accessing your database, make a backup first (always a good idea), then empty the table called txp_discuss_nonce and try logging in again.

If you’re unsure about that, drop me an email on the link in my profile and I can try and help you out directly.


TXP Builders – finely-crafted code, design and txp

Offline

#3 2019-08-29 16:22:38

mikeg
Member
From: Edmonton, Canada.
Registered: 2005-02-21
Posts: 31
Website

Re: 4.5.7 to 4.7.3 problem

Thanks Jakob! Seems to have worked. Although, now I cannot access pages, forms, or styles in the admin interface. The respective pages load, but no content is shown. The old data is still in the DB, but they just don’t show up in the interface. Any ideas?

EDIT: May have been a weird caching issue. All fixed. I really appreciate your help with this! Cheers!

Last edited by mikeg (2019-08-29 16:24:12)


“I love Beethoven. Especially the poems.”
- Ringo Starr

Offline

#4 2019-08-29 17:22:14

jakob
Admin
From: Germany
Registered: 2005-01-20
Posts: 4,578
Website

Re: 4.5.7 to 4.7.3 problem

Excellent, glad you got it working!


TXP Builders – finely-crafted code, design and txp

Offline

Board footer

Powered by FluxBB