Database errors after upgrade

[stanaca]

Today i see some database errors in my logs.

Code Select Expand

Type of error: Database
http://www.stanaca.com/index.php?pretty;board=discussions;topic=how-to-post-stories-in-this-website.new
Database Error: Duplicate entry '`T1175.msg2817' for key 1
INSERT INTO smf_pretty_urls_cache(url_id, replacement)
VALUES
('`T1175.0;prev_next=prev', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?prev_next=prev'),
('`T1175.0;prev_next=next', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?prev_next=next'),
('`T1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/'),
('`Apost;topic=1175.0;num_replies=0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=post;num_replies=0'),
('`Anotify;sa=on;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=notify;sa=on'),
('`Amarkasread;sa=topic;t=2819;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=markasread;sa=topic;t=2819'),
('`Aemailuser;sa=sendtopic;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=emailuser;sa=sendtopic'),
('`Aprintpage;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=printpage'),
('`Aquickmod2;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=quickmod2'),
('`T1175.msg2817', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/msg2817/'),
('`Apost;quote=2817;topic=1175.0;num_replies=0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=post;quote=2817;num_replies=0'),
('`Apost;msg=2817;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=post;msg=2817'),
('`Adeletemsg;topic=1175.0;msg=2817', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=deletemsg;msg=2817'),
('`Asplittopics;topic=1175.0;at=2817', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=splittopics;at=2817'),
('`Areporttm;topic=1175.0;msg=2817', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=reporttm;msg=2817'),
('`Aeditpoll;add;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=editpoll;add'),
('`Amovetopic;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=movetopic'),
('`Aremovetopic2;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=removetopic2'),
('`Alock;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=lock'),
('`Asticky;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=sticky'),
('`Amergetopics;board=22.0;from=1175', 'http://www.stanaca.com/discussions/?action=mergetopics;from=1175'),
('`Apost;calendar;msg=2817;topic=1175.0', 'http://www.stanaca.com/discussions/how-to-post-stories-in-this-website/?action=post;calendar;msg=2817')

File: /home/content/k/a/s/kashifccc/html/Sources/QueryString.php
Line: 609


This is the error to solve. i have more errors but this look dangerous.

[stanaca]

other errors in my log

to many errors like this

Code Select Expand

Type of error: Undefined

http://www.stanaca.com/index.php?pretty;action=login2&sa=check

8: Undefined index: member

File: /home/content/k/a/s/kashifccc/html/Sources/LogInOut.php
Line: 123

to many errors like this

Code Select Expand

Type of error: General
http://www.stanaca.com/index.php?pretty;board=stories.0&action=post2;start=0

2: strpos(): Offset not contained in string.

File: /home/content/k/a/s/kashifccc/html/Sources/Subs-Editor.php
Line: 958


[metallica48423]

seems related to the prettyurls mod... have you checked with the author of the mod?

topic for pretty urls can be found here: http://www.simplemachines.org/community/index.php?topic=146969.0

what is on those two lines in those two files?

[stanaca]

I should fix it or just ignore it, what is you opinion?

[metallica48423]

i'd inquire about it in that topic at the very least.

is that the only time the error showed up is when upgrading or is it recurring?

[stanaca]

i'd inquire about it in that topic at the very least.

is that the only time the error showed up is when upgrading or is it recurring?

The same error as in above posts showing frequently only in error logs.

posted the errors in pretty urls mod topic.

[metallica48423]

i have that particular topic in my unread rotation so i shall watch both topics