Problem with PMs after upgrade :: Archived

jeffk · Supporter Offline Joined: Jun 21, 2004 Posts: 322

[quote]On /index.php?name=Private_Messages&file=index&mode=newpm
While executing query "SELECT * FROM nuke_bbthemes WHERE themes_id = "

the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

In: /home/xxxxx/public_html/includes/phpBB/functions.php on line: 145

any help please

Phoenix

Sounds like you haven't uploaded templates to your themes.

jeffk · Supporter Offline Joined: Jun 21, 2004 Posts: 322

i think you have it . thx

Pontifex_Maximus

What did you do to solve this problem, jeffk? I seem to be getting the same issue after the update. When trying to access PM's or one of the Usergroups I get the same error as above. Sad

jeffk · Supporter Offline Joined: Jun 21, 2004 Posts: 322

Phoenix wrote:

Sounds like you haven't uploaded templates to your themes.

Pontifex_Maximus

jeffk wrote:

Phoenix wrote:

Sounds like you haven't uploaded templates to your themes.

I got a template folder in my /themes/DF_FiBlack3d/template/ if that's what you mean. Confused

Doesn't seem to have changed with the update to me.

rlgura

Try copying themes/default/template/Private_msgs folder to /themes/DF_FiBlack3D/template/Private_msgs

Pontifex_Maximus

omg, I'm such a nub. Shouldn't try updating stuff after midterm preparations as they fry your brain. I just had to clear the cache folder. Embarassed

Thanks for help guys, all is rolling again. Very Happy

Kinsman · Posted: Thu Jul 19, 2007 4:11 am Post subject: 9.1.2.1 Upgrade, np Prv messages

Hi all, i upgraded our site to 9.1.2.1 today, and got a few niggly problems unfortunately.

Clicking on Private Messages produces this.

A database error has occurred

The webmaster has been notified of the error

Also am receiving a lot of emails saying this.

Quote::

On /index.php?name=Private_Messages&mode=post&u=4
While executing query "SELECT * FROM cms_bbthemes WHERE themes_id = "

the following error occured: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

In: d:\web\includes\phpBB\functions.php on line: 145

Guest information:
User id: 119
Username: Holdfast
Admin: No
IP: 121.45.186.6
Host: ppp121-45-186-6.lns11.adl2.internode.on.net

i'm thinking thats related, but as a dumb enduser i cant see how. Sad

Site is here if anyone can help.

www.junglewraiths.net/index.php

NanoCaiordo

Post subject: 9.1.2.1 Upgrade, np Prv messages
cleaned and moved here.

Post subject: Problem with PMs after upgrade
as sticky

Kinsman

Thanks mate, love your work. Cool

deleted_8582 · Nice poster Offline Joined: Jun 09, 2007 Posts: 145

think its my turn here

as the administrator i get the SQL error messages that are kicked out when a users tries to do something and SQL send them the ERROR screen

today i got this in my inbox but i did the upgrade almost a month ago and its been working fine since.
(maybe no one has been checking their PMs since the upgrade lol)

Quote::

On /dragonfly2/index.php?name=Private_Messages&folder=inbox&mode=read&p=65
While executing query "SELECT u.username AS username_1, u.user_id AS user_id_1, u2.username AS username_2, u2.user_id AS user_id_2, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_avatar, pm.*, pmt.privmsgs_text
FROM cms_bbprivmsgs pm, cms_bbprivmsgs_text pmt, cms_users u, cms_users u2
WHERE pm.privmsgs_id = 65
AND pmt.privmsgs_text_id = pm.privmsgs_id
AND pm.privmsgs_to_userid = 601
AND ( pm.privmsgs_type = 0
OR pm.privmsgs_type = 1
OR pm.privmsgs_type = 5 )
AND u.user_id = pm.privmsgs_from_userid
AND u2.user_id = pm.privmsgs_to_userid"

the following error occured: Unknown column 'u.user_skype' in 'field list'

In: /home/virtual/antifm/public_html/dragonfly2/modules/Private_Messages/read.php on line: 67

Guest information:
User id: 601
Username: tigerfr3ak
Admin: No
IP: 69.125.239.90
Host: ool-457def5a.dyn.optonline.net

NanoCaiordo

Still not sure which DragonflyCMS you are using ....

antifmradio's server specs:
MySql 5.0.27-standard, php 4.4.7, CPG Nuke Vesion 9.0.6.1

deleted_8582 · Nice poster Offline Joined: Jun 09, 2007 Posts: 145

updated

unless i missed something
here is my original post

think its my turn here

as the administrator i get the SQL error messages that are kicked out when a users tries to do something and SQL send them the ERROR screen

today i got this in my inbox but i did the upgrade almost a month ago and its been working fine since.
(maybe no one has been checking their PMs since the upgrade lol)

Code::

On /dragonfly2/index.php?name=Private_Messages&folder=inbox&mode=read&p=65
While executing query "SELECT u.username AS username_1, u.user_id AS user_id_1, u2.username AS username_2, u2.user_id AS user_id_2, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_avatar, pm.*, pmt.privmsgs_text
FROM cms_bbprivmsgs pm, cms_bbprivmsgs_text pmt, cms_users u, cms_users u2
WHERE pm.privmsgs_id = 65
AND pmt.privmsgs_text_id = pm.privmsgs_id
AND pm.privmsgs_to_userid = 601
AND ( pm.privmsgs_type = 0
OR pm.privmsgs_type = 1
OR pm.privmsgs_type = 5 )
AND u.user_id = pm.privmsgs_from_userid
AND u2.user_id = pm.privmsgs_to_userid"

the following error occured: Unknown column 'u.user_skype' in 'field list'

In: /home/virtual/antifm/public_html/dragonfly2/modules/Private_Messages/read.php on line: 67

Guest information:
User id: 601
Username: tigerfr3ak
Admin: No
IP: 69.125.239.90
Host: ool-457def5a.dyn.optonline.net

NanoCaiordo

something its pretty strange here ... this is a 2 years old bug.

Looks like your tables structure went one month ago back due a restored backup? ... Is you site missing new posts, news etc etc ?