| Main | My View | View Issues | Change Log | Roadmap | Docs |
| Viewing Issue Advanced Details [ Jump to Notes ] | [ << ] [ >> ] | [ Issue History ] [ Print ] | ||||||||||
| ID | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| 0000150 | [phpBBGarage] General | minor | have not tried | 2008-12-28 13:01 | 2009-08-23 11:27 | |||||||
| Reporter | matt1206 | View Status | public | |||||||||
| Assigned To | poyntesm | |||||||||||
| Priority | normal | Resolution | open | Platform | ||||||||
| Status | feedback | OS | ||||||||||
| Projection | none | OS Version | ||||||||||
| ETA | none | Fixed in Version | Product Version | 2.0.B4 | ||||||||
| Target Version | Product Build | Pre-Modded B4 | ||||||||||
| Summary | 0000150: Error posting comments in Guest Book | |||||||||||
| Description |
When submitting a comment in the Guest Book: General Error SQL ERROR [ mysqli ] Unknown column 'u.user_garage_guestbook_pm_notify' in 'field list' [1054] SQL SELECT u.user_garage_guestbook_pm_notify, u.user_garage_guestbook_email_notify FROM (phpbb_users u) WHERE u.user_id = 56 BACKTRACE FILE: includes/db/mysqli.php LINE: 163 CALL: dbal->sql_error() FILE: includes/mods/class_garage_guestbook.php LINE: 416 CALL: dbal_mysqli->sql_query() FILE: garage_guestbook.php LINE: 222 CALL: garage_guestbook->notify_on_comment() |
|||||||||||
| Steps To Reproduce | Submitted several comments, and all produce this General Error | |||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
|
|
||||||||||||
 Relationships |
|
|
Notes |
|
|
(0000314) matt1206 (reporter) 2008-12-28 13:34 |
Just looking at an old install from Beta3, and all the Garage fields are missing from the phpbb_users table user_garage_index_columns user_garage_guestbook_email_notify user_garage_guestbook_pm_notify user_garage_mod_email_optout user_garage_mod_pm_optout |
|
(0000315) matt1206 (reporter) 2008-12-28 13:54 |
Fixed by manually adding the required fields ALTER TABLE `phpbb_users` ADD `user_garage_index_columns` tinyint(1) unsigned NOT NULL default '2', ADD `user_garage_guestbook_email_notify` tinyint(1) unsigned NOT NULL default '1', ADD `user_garage_guestbook_pm_notify` tinyint(1) unsigned NOT NULL default '1', ADD `user_garage_mod_email_optout` tinyint(1) unsigned NOT NULL default '0', ADD `user_garage_mod_pm_optout` tinyint(1) unsigned NOT NULL default '0'; |
|
(0000331) poyntesm (administrator) 2009-06-29 09:25 |
Was this fresh intall or upgrade can you remember?? |
|
(0000334) poyntesm (administrator) 2009-06-29 09:38 |
So interested in upgrade/install path |
|
(0000340) matt1206 (reporter) 2009-08-23 11:27 |
This was a fresh install of B4 |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-12-28 13:01 | matt1206 | New Issue | |
| 2008-12-28 13:34 | matt1206 | Note Added: 0000314 | |
| 2008-12-28 13:54 | matt1206 | Note Added: 0000315 | |
| 2009-06-29 09:25 | poyntesm | Note Added: 0000331 | |
| 2009-06-29 09:38 | poyntesm | Note Added: 0000334 | |
| 2009-06-29 09:38 | poyntesm | Assigned To | => poyntesm |
| 2009-06-29 09:38 | poyntesm | Status | new => feedback |
| 2009-08-23 11:27 | matt1206 | Note Added: 0000340 | |