https://www.icyphoenix.com/viewtopic.php?f=35&t=6272
-----------------------------------
gearhead
Tue 11 Aug, 2009 07:26

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)

[cell class=spoiler]
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
[/cell]


-----------------------------------
Lopalong
Tue 11 Aug, 2009 09:15

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

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

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

Re: Something I Noticed Yesterday
-----------------------------------
Done Lopa.

Posted it as Possible BUG


-----------------------------------
DWho
Tue 11 Aug, 2009 17:37

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

Re: Something I Noticed Yesterday
-----------------------------------
[quote user="DWho" post="42690"]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:[/quote]

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

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

[code linenumbers=false]Find:

	'privmsgs_text',

Comment it out:

/*
	'privmsgs_text',
*/[/code]


-----------------------------------
DWho
Wed 12 Aug, 2009 10:45

Re: Something I Noticed Yesterday
-----------------------------------
[quote user="gearhead" post="42706"]
 :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.[/quote]

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

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

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

Re: Ip_privmsgs_text' Doesn't Exist
-----------------------------------
[quote user="Lopalong" post="42712"]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

[code linenumbers=false]Find:

	'privmsgs_text',

Comment it out:

/*
	'privmsgs_text',
*/[/code][/quote]

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

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

Re: Ip_privmsgs_text' Doesn't Exist
-----------------------------------
[quote user="Mighty Gorgon" post="42807"]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.[/quote]

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

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 [b][i][size=14]screeching[/size][/i][/b] for help.

On the other hand, Old GH here took it all quite calmly. ;)


-----------------------------------
DWho
Fri 14 Aug, 2009 17:11

Re: Ip_privmsgs_text' Doesn't Exist
-----------------------------------
[quote user="Lopalong" post="42879"]@ MG,

I suppose it's not a "real" bug, but just annoying enough to no doubt having some users [b][i][size=14]screeching[/size][/i][/b] for help.

On the other hand, Old GH here took it all quite calmly. ;)[/quote]

lmao  :mryellow:  :mryellow:


-----------------------------------
gearhead
Sat 15 Aug, 2009 02:16

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:


