When I click the menu link aggregator summary, the summary of the feed does not get displayed. Instead I get the following error.

# user warning: Table 'aggregator_summary_section' doesn't exist query: select * from aggregator_summary_section in C:\documentpath\includes\database.mysql.inc on line 172.
# user warning: Table 'aggregator_summary_feed' doesn't exist query: select * from aggregator_summary_feed where fid=3 in C:\documentpath\includes\database.mysql.inc on line 172.
# user warning: Table 'aggregator_summary_feed' doesn't exist query: select * from aggregator_summary_feed where fid=4 in C:\documentpath\includes\database.mysql.inc on line 172

But those tables are already created in mulitsite one database structure with names home_summary_section and home_aggregator_summary_feed

Online Business

Comments

info@zrix.com’s picture

info@zrix.com commented
Status: Active » Closed (fixed)

Hello

Here you are getting this error because aggregator module searching tables starting with the name 'aggregator_summary_' and you renamed the table name and put 'home_' at starting of the tables and module not find table in the database as we define in the code so for solve this problem all tables related to aggregator_summery.module will start with 'aggregator_summary_'.

For example:
aggregator_summary_category
aggregator_summary_category_feed
aggregator_summary_category_item
aggregator_summary_category_section
aggregator_summary_feed
aggregator_summary_item
aggregator_summary_section

hope this will solve your problem, please let us know if any trouble u get with this process.

thanks
evakoss

wisdom’s picture

wisdom commented

In drupal installation you have the option to choose extension for tables and this is something controlled by the core. In my case home is the extension for the main site and other prefixes are also used for other sites in this multisite envioronment where several modules are running smoothly. I do not understand why this module unlike others does not work with the table prefix.

In any case I will try the way you suggested.

Online Business

wisdom’s picture

wisdom commented
Priority: Normal » Critical

Well by Drupal standard the module should work with table prefix. Drupal core is the one that handles table prefixing not individual modules. Probably you need to check with the module. This could be some bug in Aggregator Summary module itself which need to be fixed.

Table prefixing is an indispensable feature in multisite, single data base, installation. So far both the core modules and the contributes ones lend themselves to table prefixing.

Online Business

chidium’s picture

chidium commented

I am having the same problem as Wisdom on a single DB multisite install (www.haaba.com; ng.haaba.com; gh.haaba.com; za.haaba.com). I renamed the tables as per cmswebsiteservices instructions above but then I got the following error message:

* user warning: Table 'ermu_drpl1.hub_aggregator_summary_feed' doesn't exist query: SELECT COUNT(*) FROM hub_aggregator_summary_feed in /home/ermu/public_html/includes/database.mysql.inc on line 174.
* user warning: Table 'ermu_drpl1.hub_aggregator_summary_feed' doesn't exist query: SELECT * FROM hub_aggregator_summary_feed LIMIT 0, 10 in /home/ermu/public_html/includes/database.mysql.inc on line 174.

Texoor: Openquarter International

info@zrix.com’s picture

info@zrix.com commented

Hello

We are working on eliminating the issue but for now here is the way you can avoid it. You will need to get the file aggregator_summary.module from modules/aggregator_summary.

In the file you will have to put {} before and after some of the tables. Some of the tables might have these but one or two may be missing it, so you need to ensures those brackets for all the following tables.

Search the tables one by one and replace it by adding brackets
aggregator_summary_category
aggregator_summary_category_feed
aggregator_summary_category_item
aggregator_summary_category_section
aggregator_summary_feed
aggregator_summary_item
aggregator_summary_section

You will need to have all the above like this

{aggregator_summary_category}
{aggregator_summary_category_feed}
{aggregator_summary_category_item}
{aggregator_summary_category_section}
{aggregator_summary_feed}
{aggregator_summary_item}
{aggregator_summary_section}

Hopefully this will solve your problem.

chidium’s picture

chidium commented

Thanks cmswebsiteservices for your help. Very much appreciated.

This solution has taken me past this issue.

Texoor: Openquarter International