Updated to 3.0.10: Unknown Column NOTIFY_YES

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Chaos-Zero
Registered User
Posts: 55
Joined: Tue Jan 13, 2009 6:44 pm

Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by Chaos-Zero » Wed Jan 18, 2012 1:08 pm

Support Request Template
What version of phpBB are you using? phpBB 3.0.10
What is your board's URL? http://generation-lost.com/forum
Who do you host your board with? I dont know
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Update from a previous version of phpBB3
Do you have any MODs installed? Yes
Is registration required to reproduce this issue? Yes
What version of phpBB3 did you update from? phpBB 3.0.9
What MODs do you have installed? Post Count Requirements
What styles do you currently have installed? Avalon
What language(s) is your board currently using? English
Which database type/version are you using? I Don't Know
What is your level of experience? Comfortable with PHP and phpBB
What username can be used to view this issue? No answer given
What password can be used to view this issue? No answer given
When did your problem begin? After the update from 3.0.9 to 3.0.10
Please describe your problem. After the update, i removed some spam and stuff. Also i tested if the basic functions would work normally. So i tried to make a post/topic, but after hitting the submit button, i get the next message:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'NOTIFY_YES' in 'where clause' [1054]

SQL

SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber FROM phpbb_forumforums_watch w, phpbb_forumusers u WHERE w.forum_id = 4 AND w.user_id NOT IN (1, 2, 120, 132, 141, 149, 151, 156, 158, 160, 161, 166, 190, 441, 458, 459, 460, 479, 480, 482, 483, 505, 566, 588, 606, 610, 627, 629, 631, 650, 663, 669, 689, 697, 741, 745, 747, 752, 754, 757, 758, 766, 769, 775, 776, 794, 817, 822, 823, 825, 830, 831, 832, 839, 848, 859, 860, 867, 869, 871, 876, 880, 885, 888, 892, 894, 901, 908, 910, 912, 917, 918, 928, 929, 932, 936, 937, 941, 944, 947, 951, 957, 958, 960, 967, 981, 983, 984, 990, 991, 993, 999, 1003, 1005, 1033, 1061, 1071, 1079, 1080, 1108, 1141, 1143, 1156, 1169, 1183, 1269, 1277, 1297, 1375, 1386, 1392, 1399, 1403, 1422, 1425, 1440, 1469, 1500, 1514, 1537, 1538, 1539, 1541, 1542, 1564, 1582, 1586, 1589, 1603, 1605, 1610, 1616, 1638, 1640, 1641, 1642, 1644, 1647, 1648, 1650, 1652, 1654, 1656, 1658, 1659, 1660, 1661, 1663, 1665, 1666, 1689, 1693, 1694, 1712, 1716, 1744, 1768, 1780, 1796, 1812, 1823, 1832, 1835, 1844, 1848, 1852, 1860, 1865, 1879, 1880, 1919, 1924, 1927, 1948, 1965, 1981, 1987, 1988, 1994, 2006, 2009, 2032, 2035, 2051, 2052, 2053, 2054, 2055) AND w.notify_status = NOTIFY_YES AND u.user_type IN (0, 3) AND u.user_id = w.user_id

BACKTRACE

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/functions_posting.php
LINE: 1207
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/functions_posting.php
LINE: 2588
CALL: user_notification()

FILE: [ROOT]/posting.php
LINE: 1130
CALL: submit_post()

The post is made, but i get every time this message. I know after some research that it has to do with constant.php, but i dont know how to solve this.
Generated by SRT Generator

User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by HGN » Wed Jan 18, 2012 2:13 pm

Do you have these lines in /includes/constants.php?

Code: Select all

// Notify status
define('NOTIFY_YES', 0);
define('NOTIFY_NO', 1);
 

Chaos-Zero
Registered User
Posts: 55
Joined: Tue Jan 13, 2009 6:44 pm

Re: Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by Chaos-Zero » Wed Jan 18, 2012 2:52 pm

HGN wrote:Do you have these lines in /includes/constants.php?

Code: Select all

// Notify status
define('NOTIFY_YES', 0);
define('NOTIFY_NO', 1);
 
No, i cant find it in the file. Where should i add it?

Edit: i guess it doesnt matter, because its working again. Thanks for your help!

Chaos-Zero
Registered User
Posts: 55
Joined: Tue Jan 13, 2009 6:44 pm

Re: Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by Chaos-Zero » Thu Jan 19, 2012 11:03 am

I have a new problem. When i go to ACP ill get the next msg:
General Error
SQL ERROR [ mysql4 ]

Unknown column 'LOGIN_ATTEMPTS_MAX' in 'where clause' [1054]

SQL

UPDATE phpbb_forumusers SET user_login_attempts = user_login_attempts + 1 WHERE user_id = 2 AND user_login_attempts < LOGIN_ATTEMPTS_MAX

BACKTRACE

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/includes/auth/auth_db.php
LINE: 266
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/auth.php
LINE: 919
CALL: login_db()

FILE: [ROOT]/includes/functions.php
LINE: 2888
CALL: auth->login()

FILE: [ROOT]/adm/index.php
LINE: 33
CALL: login_box()
This is weird, because yesterday after the update it did work good..

User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by HGN » Thu Jan 19, 2012 11:39 am

Again that is a parameter defined in constants.php.
I suggest to downaload a fresh copy of the 3.0.10 files, unzip constants.php and upload that file to /includes/.

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69353
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by KevC » Thu Jan 19, 2012 11:40 am

Your includes/constants.php file is not up to date.

You seem to have some incomplete updates along the line. As you only have one MOD I'd suggest a file replacement and reinstall the MOD.

*NOTE: Before proceeding backup all files and the database.*
  • Upload all new files from a download of the full version, EXCEPT for config.php, the /images and /files folders.
  • Go to yoursite.com/forumfolder/install/database_update.php
  • Let that run and then delete the install folder.
  • You now have a new up to date board containing all your users and posts but without any MODs that you might have had installed.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Chaos-Zero
Registered User
Posts: 55
Joined: Tue Jan 13, 2009 6:44 pm

Re: Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by Chaos-Zero » Thu Jan 19, 2012 6:11 pm

Hmm installed more mods, but i dont know which ones exactly. I fixed this problem by replacing the constant.php with a new one, but now i have an error when opening a topic.
SQL ERROR [ mysql4 ]

Table 'alex_forum.SHARE_TOPIC_TABLE' doesn't exist [1146]

SQL

SELECT * FROM SHARE_TOPIC_TABLE

BACKTRACE

FILE: [ROOT]/includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: [ROOT]/viewtopic.php
LINE: 681
CALL: dbal_mysql->sql_query()

User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by HGN » Thu Jan 19, 2012 6:22 pm

*EDIT* probably disn't look carefull enough to previous post.

Is SHARE the prefix for all your tables, as specified in config.php ($table_prefix = 'share_';)?

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by D¡cky » Thu Jan 19, 2012 7:12 pm

When you uploaded the fresh constants.php file, you would have lost any constants for tables that your MODs added. You will need to go through your MOD installation instruction and see which ones modified the constants.php file or if you have a backup of the constants.php file, look under the Additional Tables section for tables that MODs have added.
Have you hugged someone today?

User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by HGN » Thu Jan 19, 2012 9:47 pm

HGN wrote:*EDIT* probably disn't look carefull enough to previous post.

Is SHARE the prefix for all your tables, as specified in config.php ($table_prefix = 'share_';)?
From you previous posts I see that your tableprefix is phpbb_, so whatever is on line 681 of viewtopic.php has been added by you installing one of the mods. However, the code does not seem to be correct.

You should try to find for which of the mods you had to modify viewtopic.php and which mod added something like that.

Also you should document at least which mods you install.
Also don't install several mods at the same time, but do it one by one and test the board carefully after installing a mod. Otherwise you will be lost whenever an error occurs.

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69353
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by KevC » Thu Jan 19, 2012 9:53 pm

I think the SHARE_TOPIC_TABLE error is from this MOD
http://www.phpbb.com/customise/db/mod/share_topic/
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
HGN
Former Team Member
Posts: 4706
Joined: Wed Dec 03, 2008 1:53 pm
Location: The Netherlands
Name: Alfred
Contact:

Re: Updated to 3.0.10: Unknown Column NOTIFY_YES

Post by HGN » Thu Jan 19, 2012 10:09 pm

Yes, you are most probably correct.

That one adds the following line to constants.php below "// Additional tables":

Code: Select all

define('SHARE_TOPIC_TABLE',				$table_prefix . 'share');

Locked

Return to “[3.0.x] Support Forum”