vBNotifications Beta Updated

Status
Not open for further replies.
Hey David, thanks for the update. Everything seems to work fine except in the admin cp when clicking on "No(Click to Activate)" when making a notification dissmissable I get a database error:

PHP: 
Database error in vBulletin 4.1.4:

Invalid SQL:

			UPDATE dbtech_notifications_types
			SET
				dismissable = 1
			WHERE typeid = 'pmunread';

MySQL Error   : Unknown column 'dismissable' in 'field list'
Error Number  : 1054
Request Date  : Monday, July 11th 2011 @ 04:41:36 PM
Error Date    : Monday, July 11th 2011 @ 04:41:36 PM
Script        : http://development.aniworlds.net/admincp/vbnotifs.php?do=checkdismiss&typeid=pmunread
Referrer      : http://development.aniworlds.net/admincp/vbnotifs.php?do=types
IP Address    : xxxxxxxxxxxxx
Username      : AWDevelopment
Classname     : vB_Database
MySQL Version : 5.0.77

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 423
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 441
#2 vB_Database->query_write() called in [path]/dbtech/notifications/actions/admin/checkdismiss.php on line 54
#3 include_once([path]/dbtech/notifications/actions/admin/checkdismiss.php) called in [path]/admincp/vbnotifs.php on line 87

Seems as though the upgrade product did not create the new table perhaps. Everything else though so far so good. You have my info use it if you may it's still valid. :)

P.S.: This is with version 1.0.1 of the product.
 
EquinoxAW said:
Hey David, thanks for the update. Everything seems to work fine except in the admin cp when clicking on "No(Click to Activate)" when making a notification dissmissable I get a database error:

PHP: 
Database error in vBulletin 4.1.4:

Invalid SQL:

			UPDATE dbtech_notifications_types
			SET
				dismissable = 1
			WHERE typeid = 'pmunread';

MySQL Error   : Unknown column 'dismissable' in 'field list'
Error Number  : 1054
Request Date  : Monday, July 11th 2011 @ 04:41:36 PM
Error Date    : Monday, July 11th 2011 @ 04:41:36 PM
Script        : http://development.aniworlds.net/admincp/vbnotifs.php?do=checkdismiss&typeid=pmunread
Referrer      : http://development.aniworlds.net/admincp/vbnotifs.php?do=types
IP Address    : xxxxxxxxxxxxx
Username      : AWDevelopment
Classname     : vB_Database
MySQL Version : 5.0.77

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 423
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 441
#2 vB_Database->query_write() called in [path]/dbtech/notifications/actions/admin/checkdismiss.php on line 54
#3 include_once([path]/dbtech/notifications/actions/admin/checkdismiss.php) called in [path]/admincp/vbnotifs.php on line 87

Seems as though the upgrade product did not create the new table perhaps. Everything else though so far so good. You have my info use it if you may it's still valid. :)

P.S.: This is with version 1.0.1 of the product.
Click to expand...
Could you run the following query please :)

Code: 
ALTER TABLE {{TABLE PREFIX}}dbtech_notifications_types
ADD COLUMN dismissable TINYINT(1) NOT NULL DEFAULT '1'

That should fix things for you! I'll have a look at the upgrade code! :)
 
David said:
Could you run the following query please :)

Code: 
ALTER TABLE {{TABLE PREFIX}}dbtech_notifications_types
ADD COLUMN dismissable TINYINT(1) NOT NULL DEFAULT '1'

That should fix things for you! I'll have a look at the upgrade code! :)
Click to expand...
This should now be fixed. If you are currently receiving the above error then please run the above query!
 
Hey David maybe I didn't copy that query correctly but I'm getting this error when running that.:
#1064 - 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 '{{TABLE PREFIX}}dbtech_notifications_types
ADD COLUMN dismissable TINYINT(1) NO' at line 1
Click to expand...

This is what I'm using:
ALTER TABLE {{TABLE PREFIX}}dbtech_notifications_types
ADD COLUMN dismissable TINYINT(1) NOT NULL DEFAULT '1'
Click to expand...
 
EquinoxAW said:
Hey David maybe I didn't copy that query correctly but I'm getting this error when running that.:


This is what I'm using:
Click to expand...
You need to change {{TABLE PREFIX}} to your table prefix. Sorry for not making that more clear! :)
 
Awesome David I am using vB 4.1.4 and this is the first update 1.0.1 that I can see the configure in settings. :)
I have selected Active and usergroups but can not see any Permanent Notifications.
 
GoodApples said:
Awesome David I am using vB 4.1.4 and this is the first update 1.0.1 that I can see the configure in settings. :)
I have selected Active and usergroups but can not see any Permanent Notifications.
Click to expand...
Could you send me some login info please! :)
 
David said:
Are you sure you weren't sending the message to yourself?
Click to expand...
Laughing well I have done that here on dbtech :) and it works !

but No did not send it to myself :)

Edit: Tested Sending Message to self for Notifications.
it worked here on dbtech I have "Unread Private Message(1)" :)
 
Last edited:
Status
Not open for further replies.

Legacy vBNotifications

vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
520
Customer rating
0.00 star(s) 0 ratings
Back
Top