Icy Phoenix
Old Support Topics - Ip_privmsgs_text' Doesn't Exist
gearhead [ Tue 11 Aug, 2009 07:26 ]
Post subject: Ip_privmsgs_text' Doesn't Exist
This is just meant as an actual report after 1 week of using IP 1.3, which is fantastic by the way with many major improvements.....
I noticed last night that the ajax shout box quit working. By that I mean that I couldn't add a comment to the box. It may be a server/host issue, but the way I fixed it, was to delete the ajax shout box, and install a new one....kinda like changing a spark plug.....
Other than that, no other problems so far with my new install of IP 1.3.
One other report I can make so far is that when checking mysql witin IP 1.3, I found this:
Path: DB and security>Database maintenance>Check database for errors> (the prefix for my ip tables is 3ip_ by the way....(did that to make it unique).
Maybe I'm short one table in the database? It's stating that it needs that one table to read: 3ip_privmsgs_text is the wrong name, or missing...there's 150 tables total.
See below: (I'm only showing the middle section of mysql tables)
3ip_pa_votes: OK
3ip_posts: OK
3ip_privmsgs: OK
3ip_privmsgs_archive: OK
3ip_privmsgs_text: Table 'phoenix2009.3ip_privmsgs_text' doesn't exist
3ip_profile_fields: OK
3ip_profile_view: OK
3ip_quota_limits: OK
3ip_ranks: OK
Lopalong [ Tue 11 Aug, 2009 09:15 ]
Post subject: Re: Something I Noticed Yesterday
What about a new thread with the title "ip_privmsgs_text' doesn't exist " ;)
spydie [ Tue 11 Aug, 2009 10:14 ]
Post subject: Re: Something I Noticed Yesterday
This is definatly right.
_privatmsgs and privatmsgs_archive are the only tables about privat messages in the install DB
Maybe we should ask MG about the importance of This Table, since he´s the one who wrote this.
Maybe we should post this as a BUG
Lopalong [ Tue 11 Aug, 2009 11:54 ]
Post subject: Re: Something I Noticed Yesterday
That's why I'd like to see it as a new thread, because I'd like to find out the answers too - along with a lot of other people no doubt. ;)
spydie [ Tue 11 Aug, 2009 12:01 ]
Post subject: Re: Something I Noticed Yesterday
Done Lopa.
Posted it as Possible BUG
DWho [ Tue 11 Aug, 2009 17:37 ]
Post subject: Re: Something I Noticed Yesterday
ip_privmsgs_text is not included in icy1.3 MG combined the 2 tables to make one...
is this error showing on any pages in icy1.3 or just a database report...
if making new mods... you have to remove all reference of ip_privmsgs_text and combine it with ip_privmsgs..
FYI
:mrgreen: :mrgreen:
gearhead [ Wed 12 Aug, 2009 00:56 ]
Post subject: Re: Something I Noticed Yesterday
ip_privmsgs_text is not included in icy1.3 MG combined the 2 tables to make one...
is this error showing on any pages in icy1.3 or just a database report...
if making new mods... you have to remove all reference of ip_privmsgs_text and combine it with ip_privmsgs..
FYI
:mrgreen: :mrgreen:
Thanks guys. I think that explains it since those tables are combined. It's just a database report. It seems not to affect the operation of the board; it's just something I was looking for an explanation for.....
Thanks Dr. Who and Spidie.
Lopalong [ Wed 12 Aug, 2009 02:18 ]
Post subject: Re: Ip_privmsgs_text' Doesn't Exist
It appears to be something left over and is not used in the "New" optimise database or in IP3 etc.
I think that this is pretty safe to do.
Open includes/functions_dbmtnc.php
Find:
'privmsgs_text',
Comment it out:
/*
'privmsgs_text',
*/
DWho [ Wed 12 Aug, 2009 10:45 ]
Post subject: Re: Something I Noticed Yesterday
:mrgreen: :mrgreen:
Thanks guys. I think that explains it since those tables are combined. It's just a database report. It seems not to affect the operation of the board; it's just something I was looking for an explanation for.....
Thanks Dr. Who and Spidie.
not a problm took me ages when ifirst so that error after upgrading a mod... but when I realised it no longer existed..
made it a lot easier..
:mrgreen: :mrgreen:
Lopalong [ Wed 12 Aug, 2009 11:37 ]
Post subject: Re: Ip_privmsgs_text' Doesn't Exist
If anything it should be posted in the Bug Tracker so that there's no chance of MG missing it. Unwanted errors are bugs. ;)
DWho [ Wed 12 Aug, 2009 17:33 ]
Post subject: Re: Ip_privmsgs_text' Doesn't Exist
I will link back to this topic in the bug section so Mg can see it and the work around...
:mrgreen: :mrgreen:
gearhead [ Thu 13 Aug, 2009 03:14 ]
Post subject: Re: Ip_privmsgs_text' Doesn't Exist
It appears to be something left over and is not used in the "New" optimise database or in IP3 etc.
I think that this is pretty safe to do.
Open includes/functions_dbmtnc.php
Find:
'privmsgs_text',
Comment it out:
/*
'privmsgs_text',
*/
Performed fix, and all is well. No more 'perceived errors by the database test', plus, page load is faster! I would guess since the php command is now ignored, and server request is not returned with a un-needed operation!
Thanks, Lopalong.... :D
Mighty Gorgon [ Fri 14 Aug, 2009 01:33 ]
Post subject: Re: Ip_privmsgs_text' Doesn't Exist
I just forgot to remove that table from that file... it is safe that you remove it on your own.
I will fix it in the first 1.3 patch.
I have already fixed some bugs.
gearhead [ Fri 14 Aug, 2009 02:30 ]
Post subject: Re: Ip_privmsgs_text' Doesn't Exist
I just forgot to remove that table from that file... it is safe that you remove it on your own.
I will fix it in the first 1.3 patch.
I have already fixed some bugs.
Thank you very much, 1.3 is great, great, great, anyway...my users like it way better! (So do I).
:mricy:
Lopalong [ Fri 14 Aug, 2009 15:36 ]
Post subject: Re: Ip_privmsgs_text' Doesn't Exist
@ MG,
I suppose it's not a "real" bug, but just annoying enough to no doubt having some users screeching for help.
On the other hand, Old GH here took it all quite calmly. ;)
DWho [ Fri 14 Aug, 2009 17:11 ]
Post subject: Re: Ip_privmsgs_text' Doesn't Exist
@ MG,
I suppose it's not a "real" bug, but just annoying enough to no doubt having some users screeching for help.
On the other hand, Old GH here took it all quite calmly. ;)
lmao :mryellow: :mryellow:
gearhead [ Sat 15 Aug, 2009 02:16 ]
Post subject: Re: Ip_privmsgs_text' Doesn't Exist
Thanks lop, I try to stay cool and not panic. Since there wasn't anything going wrong with IP 1.3, I figured it's an easy fix, and thanks everyone for enjoying my calmness.....
:mricy: