(Click to enlarge)

Hi,

What makes you conclude it's not installed? I think there is something on the Setup menu, please confirm there are no links on the admin menus with 'Classifieds' in.

The only indication is that under "Setup" there is a link to "Classified Pricing", however, when attempting to invoke that, the following error report is given:

An error has occurred

Unfortunately a query has failed [SELECT * FROM oc_classifieds_prices WHERE 1=1 ORDER BY c_catalogue_name,c_days,c_price] [Table 'townsf5_ocpo250.oc_classifieds_prices' doesn't exist] (version: 10.0.1, PHP version: 5.6.30, URL: /adminzone/index.php?page=admin-classifieds)

Here is the stack trace:

Below is a stack trace revealing the state Composr was in when the error occurred. If this represents a bug in the unmodified software, you may want to check Composr website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information.
We apologise for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly.

File '/home/townsf5/public_html/sources/failure.php'
Line 977
Function 'get_html_trace'
Args
File '/home/townsf5/public_html/sources/global2.php'
Line 919
Function '_fatal_exit'
Args
Tempcode -> Unfortunately a query has failed [SELECT * FROM oc_classifieds_prices WHERE 1=1 ORDER BY c_catalogue_name,c_days,c_price] [<strong>Table 'townsf5_ocpo250.oc_classifieds_prices' doesn't exist</strong>]
File '/home/townsf5/public_html/sources/database/mysqli.php'
Line 261
Function 'fatal_exit'
Args
Tempcode -> Unfortunately a query has failed [SELECT * FROM oc_classifieds_prices WHERE 1=1 ORDER BY c_catalogue_name,c_days,c_price] [<strong>Table 'townsf5_ocpo250.oc_classifieds_prices' doesn't exist</strong>]
File '/home/townsf5/public_html/sources/database.php'
Line 1,374
Function 'db_query'
Class 'Database_Static_mysqli'
Object O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:53:"a:2:{i:0;s:15:"townsf5_ocpo250";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}}s:14:"last_select_db";a:2:{i:0;r:3;i:1;s:15:"townsf5_ocpo250";}s:16:"reconnected_once";b:0;}
Type '->'
Args
'SELECT * FROM oc_classifieds_prices WHERE 1=1 ORDER BY c_catalogue_name,c_days,c_price'

array

NULL

NULL

false

false

false

false
File '/home/townsf5/public_html/sources/database.php'
Line 996
Function '_query'
Class 'DatabaseConnector'
Object O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:3:"oc_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:15:"townsf5_ocpo250";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:15:"townsf5_ocpo250";}s:26:"text_lookup_original_cache";a:14:{i:34;s:14:"Administrators";i:35;s:13:"Site director";i:7;s:7:"Welcome";i:8;s:10:"Admin Zone";i:11;s:18:"Content Management";i:10;s:18:"Collaboration Zone";i:13;s:6:"Forums";i:9;s:4:"Site";i:1;s:0:"";i:2;s:10:"Admin Zone";i:5;s:18:"Content Management";i:3;s:18:"Collaboration Zone";i:12;s:5:"Forum";i:4;s:0:"";}s:17:"text_lookup_cache";a:14:{i:34;s:0:"";i:35;s:0:"";i:7;s:0:"";i:8;s:0:"";i:11;s:0:"";i:10;s:0:"";i:13;s:0:"";i:9;s:0:"";i:1;s:0:"";i:2;s:0:"";i:5;s:0:"";i:3;s:0:"";i:12;s:0:"";i:4;s:0:"";}s:18:"table_exists_cache";a:0:{}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:53:"a:2:{i:0;s:15:"townsf5_ocpo250";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:15:"townsf5_ocpo250";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type '->'
Args
'SELECT * FROM oc_classifieds_prices WHERE 1=1 ORDER BY c_catalogue_name,c_days,c_price'

NULL

NULL

false

false

a:0:{}

''
File '/home/townsf5/public_html/adminzone/pages/minimodules_custom/admin_classifieds.php'
Line 79
Function 'query_select'
Class 'DatabaseConnector'
Object O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:3:"oc_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:15:"townsf5_ocpo250";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:15:"townsf5_ocpo250";}s:26:"text_lookup_original_cache";a:14:{i:34;s:14:"Administrators";i:35;s:13:"Site director";i:7;s:7:"Welcome";i:8;s:10:"Admin Zone";i:11;s:18:"Content Management";i:10;s:18:"Collaboration Zone";i:13;s:6:"Forums";i:9;s:4:"Site";i:1;s:0:"";i:2;s:10:"Admin Zone";i:5;s:18:"Content Management";i:3;s:18:"Collaboration Zone";i:12;s:5:"Forum";i:4;s:0:"";}s:17:"text_lookup_cache";a:14:{i:34;s:0:"";i:35;s:0:"";i:7;s:0:"";i:8;s:0:"";i:11;s:0:"";i:10;s:0:"";i:13;s:0:"";i:9;s:0:"";i:1;s:0:"";i:2;s:0:"";i:5;s:0:"";i:3;s:0:"";i:12;s:0:"";i:4;s:0:"";}s:18:"table_exists_cache";a:0:{}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:53:"a:2:{i:0;s:15:"townsf5_ocpo250";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:15:"townsf5_ocpo250";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type '->'
Args
'classifieds_prices'

a:1:{i:0;s:1:"*";}

NULL

'ORDER BY c_catalogue_name,c_days,c_price'
File '/home/townsf5/public_html/sources/zones.php'
Line 628
Args
'/home/townsf5/public_html/adminzone/pages/minimodules_custom/admin_classifieds.php'
Function 'require'
File '/home/townsf5/public_html/sources/zones.php'
Line 605
Function '_load_mini_code'
Args
'adminzone/pages/minimodules_custom/admin_classifieds.php'
File '/home/townsf5/public_html/sources/site.php'
Line 1,221
Function 'load_minimodule_page'
Args
'adminzone/pages/minimodules_custom/admin_classifieds.php'

Tempcode -> ...
File '/home/townsf5/public_html/sources/site.php'
Line 890
Function 'request_page'
Args
'admin_classifieds'

true

NULL

NULL

false

false

Tempcode -> ...
File '/home/townsf5/public_html/adminzone/index.php'
Line 56
Function 'do_site'
Args
Back to the top Commandr: the Composr command line environment Chat with other Composr users (Select page rendering tool) Go
A A A
Home Sitemap Rules Privacy Feedback Log out Mobile version My ocPortal Keyboard shortcuts

Hi,

With the screenshot, is that taken in the short amount of time before it redirects back to the addon list, or does it not redirect?

I tried hard to reproduce, or to find a bug via code analysis, and I came up blank.

Did you uncheck any of the files when it lists the files in the addon?

If you want me to look directly on your server I'll be happy to, but I'll need access (send to [email protected]).

Maybe the issue is you had a problem installing way before (even on ocPortal) and it left it in a semi-installed state. It will only auto-install the module again if it doesn't think it is already installed.

You can workaround by going to
http://townsforum.com/site/?page=classifieds

It will force an install of the classifieds module (which is what somehow did not run), and then the admin module will run too.