I am quite sure there is no room for someone of my skill level messing with this module however I am fascinated by what is being done here. With that said you must know that when faced with a problem or challenge I don't easily give into the notion of giving way to the problem.

The likelihood of missing a step during the install is probable however I've followed the instructions and am receiving several lines of issues. My hosting replied they did install Python Numeric and Pycluster but I am unaware how to verify installations.

Here is what is displayed:


    * user warning: Table 'ladyogol_drpl1.memetracker_content' doesn't exist query: SELECT cid, content_type FROM memetracker_content WHERE mid = 1 and timestamp > 1218642923 in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.inc on line 67.
    * user warning: Table 'ladyogol_drpl1.memetracker_content' doesn't exist query: SELECT cid FROM memetracker_content WHERE mid = 1 AND timestamp > 1218642920 in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.inc on line 178.
    * user warning: Table 'ladyogol_drpl1.memetracker_content' doesn't exist query: DELETE FROM memetracker_content WHERE mid = 1 AND timestamp > 1218642920 in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.inc on line 182.
    * user warning: 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 ') OR cid2 in ()' at line 2 query: DELETE FROM machinelearningapi_distance_cache WHERE cid1 IN () OR cid2 in () in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.inc on line 198.
    * user warning: Table 'ladyogol_drpl1.memetracker_content' doesn't exist query: SELECT cid, content_type FROM memetracker_content WHERE mid = 0 and timestamp > 1218642923 in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.inc on line 212.
    * user warning: Table 'ladyogol_drpl1.memetracker_content' doesn't exist query: SELECT fni.nid, fni.timestamp, f.link, f.nid as fid FROM feedapi f JOIN feedapi_node_item_feed ff JOIN feedapi_node_item fni WHERE fni.timestamp > 1218642925 AND f.nid in (0) AND f.nid = ff.feed_nid AND ff.feed_item_nid = fni.nid AND fni.nid NOT IN (SELECT int_id FROM memetracker_content WHERE mid = 1) in /home/ladyogol/public_html/sites/all/modules/memetracker/content_source.inc on line 186.

I am seeking assistance from anyone able to sort this out with me.

Thanks,

Jerry

Comments

manogolf’s picture

manogolf commented
Category: bug » support
manogolf’s picture

manogolf commented

I have gotten closer to a working installation. I am down to one error message and if I continue to fuss with things maybe it will go away as well. Here is what is now showing:

user warning: 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 ') OR cid2 in ()' at line 2 query: DELETE FROM machinelearningapi_distance_cache WHERE cid1 IN () OR cid2 in () in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.inc on line 198.

Thanks,

Jerry

bonobo’s picture

bonobo commented

Can you include any additional detail on your setup process? What steps did you take to eliminate the initial errors?

Also, if you could include the OS of your server, and the PHP/MySQL versions you are using, that would also be helpful.

Are you running any additional modules on your site, or only memetracker and related dependencies?

manogolf’s picture

manogolf commented

Keep in mind my experience is from trial and error and I have no real knowledge of what the heck I'm doing. With that said.

I tried nearly everything possible trying to keep error reports from showing. In the end the simplest approach worked. In the modules area there is a tab to uninstall modules. I checked all the feedapi, memetracker and machinelearning apps and uninstalled them. Then I reinstalled everything and was left with the one error noted. I found in the memtracker.inc file the line 198 code but do not know correct syntax. Is this correct?

db_query("DELETE FROM {machinelearningapi_distance_cache} WHERE cid1 IN 
    ($cids) OR cid2 in ($cids)");

Oddly the memes were showing up as nodes posted in my content even with the errors. The page at http://yourdomain/com/memetracker/1/ reported there were no memes to show which made things even weirder.

After my reinstall I go to /memetracker/1/ there is a page of new error reports:

# user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: SELECT content FROM memetracker_search_1 WHERE cid = 12 in /home/ladyogol/public_html/sites/all/modules/memetracker/content.inc on line 172.
# user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: SELECT content FROM memetracker_search_1 WHERE cid = 13 in /home/ladyogol/public_html/sites/all/modules/memetracker/content.inc on line 172.
# user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: SELECT content FROM memetracker_search_1 WHERE cid = 15 in /home/ladyogol/public_html/sites/all/modules/memetracker/content.inc on line 172.
# user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: SELECT content FROM memetracker_search_1 WHERE cid = 14 in /home/ladyogol/public_html/sites/all/modules/memetracker/content.inc on line 172.
# user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: SELECT content FROM memetracker_search_1 WHERE cid = 11 in /home/ladyogol/public_html/sites/all/modules/memetracker/content.inc on line 172.
# user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: SELECT content FROM memetracker_search_1 WHERE cid = 12 in /home/ladyogol/public_html/sites/all/modules/memetracker/content.inc on line 172.
# user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: SELECT content FROM memetracker_search_1 WHERE cid = 13 in /home/ladyogol/public_html/sites/all/modules/memetracker/content.inc on line 172.
# user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: SELECT content FROM memetracker_search_1 WHERE cid = 15 in /home/ladyogol/public_html/sites/all/modules/memetracker/content.inc on line 172.
# user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: SELECT content FROM memetracker_search_1 WHERE cid = 14 in /home/ladyogol/public_html/sites/all/modules/memetracker/content.inc on line 172.

And this display is repeated three times. This time the memes are showing below the error code whereas before it reported I had no memes to show.

Server info as follows:

OS: Linux
php: 4.4.8 (I edited my .htaccess file at the root to include this: AddType application/x-httpd-php5 .php5 .php

MySQL version 4.1.22-standard-log

I am running several other modules on my site. Against all common knowledge I am running this on a live site. Not one I really care about though.

As follows:

OpenX Adserver Integration
Simple Ads
Common syndication parser
FeedAPI Inherit
FeedAPI
FeedAPI Node
SimplePie parser
machinelearningapi
Memetracker
BlockAnonymousLinks
Blockquotes
Google Analytics
Pathauto
Poormanscron
Tiny Tiny MCE
Token
Token actions

I've turned them off or on and it does not seem to matter.

Thats what I know. Thanks for looking.

Jerry

kyle_mathews’s picture

kyle_mathews commented

Hi Jerry,
Alpha 6 should of gotten rid of your first error. Are you still getting a message saying Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist

Sorry for the delay in getting back to you -- I've was traveling and now am getting started back in school.

manogolf’s picture

manogolf commented

Hi Kyle,

Yes I am still receiving the messages user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: SELECT content FROM memetracker_search_1 WHERE cid = 1 in /home/ladyogol/public_html/sites/all/modules/memetracker/content.inc on line 172.

I would post the seemingly endless lines similar to this one received after cron is run but you probably get the idea. I have updated to alpha 6.

Jerry

kyle_mathews’s picture

kyle_mathews commented

Jerry,
It seems that the table it's complaining about (memetracker_search_1) just wasn't created. I've never had that particular table turn up missing and neither has anyone else complained about it before so I'm guessing your database just hiccuped when creating the tables. Try completely uninstalling memetracker and machinelearningapi -- so uncheck the modules, then submit, then click on the uninstall tab at the top of the page, and select the two modules to be uninstalled. This will remove the tables from the database. Then reinstall the two modules. Hopefully that'll get rid of any problems.

manogolf’s picture

manogolf commented

Kyle,

I've tried that a multiple of times, but why not another. I'll report back.

Thanks and it is certainly good to have you back.

I forgot to mention when uninstalling a similar reference exists which makes sense. user warning: Unknown table 'memetracker_search_1' query: DROP TABLE memetracker_search_1 in /home/ladyogol/public_html/includes/database.mysql-common.inc on line 261.

manogolf’s picture

manogolf commented

Kyle,

This shows after re-installing (disappears after running cron)

    * user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_1 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/ladyogol/public_html/includes/database.inc on line 514.
    * user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_2 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/ladyogol/public_html/includes/database.inc on line 514.
    * user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_3 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/ladyogol/public_html/includes/database.inc on line 514.
    * user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_4 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/ladyogol/public_html/includes/database.inc on line 514.
    * user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_5 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/ladyogol/public_html/includes/database.inc on line 514.
    * user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_6 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/ladyogol/public_html/includes/database.inc on line 514.
    * user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_7 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/ladyogol/public_html/includes/database.inc on line 514.
    * user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_8 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/ladyogol/public_html/includes/database.inc on line 514.
    * user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_9 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/ladyogol/public_html/includes/database.inc on line 514.
    * user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_10 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/ladyogol/public_html/includes/database.inc on line 514.
    * user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_1 (content) in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.install on line 465.
    * user warning: Table 'ladyogol_drpl1.memetracker_search_2' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_2 (content) in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.install on line 467.
    * user warning: Table 'ladyogol_drpl1.memetracker_search_3' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_3 (content) in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.install on line 469.
    * user warning: Table 'ladyogol_drpl1.memetracker_search_4' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_4 (content) in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.install on line 471.
    * user warning: Table 'ladyogol_drpl1.memetracker_search_5' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_5 (content) in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.install on line 473.
    * user warning: Table 'ladyogol_drpl1.memetracker_search_6' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_6 (content) in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.install on line 475.
    * user warning: Table 'ladyogol_drpl1.memetracker_search_7' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_7 (content) in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.install on line 477.
    * user warning: Table 'ladyogol_drpl1.memetracker_search_8' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_8 (content) in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.install on line 479.
    * user warning: Table 'ladyogol_drpl1.memetracker_search_9' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_9 (content) in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.install on line 481.
    * user warning: Table 'ladyogol_drpl1.memetracker_search_10' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_10 (content) in /home/ladyogol/public_html/sites/all/modules/memetracker/memetracker.install on line 483.

Then after adding feeds

user warning: Table 'ladyogol_drpl1.memetracker_search_1' doesn't exist query: INSERT INTO memetracker_search_1 (cid, content) VALUES (1, 'Sacred Heart: SHU Women tied for 8th after Day 1 of Dartmouth Invite. The Sacred Heart women\'s golf team sits tied for eighth place after the first day of the Dartmouth Invitational on Saturday. The Pioneers shot a team score of 326 and are tied with Williams College just four strokes behind Amherst in seventh and six back of Fairfield in sixth.') in /home/ladyogol/public_html/sites/all/modules/memetracker/content.inc on line 344.

This is just one line of many.

And like before when I view /memtracker/1 all memes are displayed under the error reports.

Jerry

kyle_mathews’s picture

kyle_mathews commented

Jerry,
Thanks for including the all the errors -- that helped in debugging. I think I found the problem -- look at this issue: http://drupal.org/node/282948

It seems older versions of MySQL (<5) set a limit of 256 characters for certain types of columns. Memetracker tries to create columns with more characters than that which causes MySQL to complain and the table doesn't end up being created.

Check what version of MySQL you have. I'll look into changing how I define the columns so it'll work under MySQL 4.x

manogolf’s picture

manogolf commented

Yea the version is MySQL version 4.1.22-standard-log. Not much I can do about it because hosting is on a shared server.
If you can work it out that would be great.

Jerry

bonobo’s picture

bonobo commented

In the shorter term, it would probably be good to document that MySQL 5 is required.

kyle_mathews’s picture

kyle_mathews commented

Bill,
I think it'd just take a simple change in the database from using a varchar column type to a text column -- I'll test it though.

manogolf’s picture

manogolf commented

Have you had any time for testing?

Jerry

kyle_mathews’s picture

kyle_mathews commented

Not yet. . . hopefully on Saturday?

manogolf’s picture

manogolf commented

Kyle,

Unable to stand idle I found a host that provides VPS technology which allowed me to install mysql 5.x. The learning curve going from cPanel to linux continues to be challenging but after fussing with a bunch of new terms and interface software I've managed to install python and the recommended python dependencies. I can happily report a working installation of memetracker. Nodes appear on the front page, there are no errors to report, and all seems well.

Now for some usage questions. I am building a news type site and using a theme which offers blocks in regions on the page. Is there a way to display the nodes created by memetracker in one of these blocks? Certainly a link to the memetracker page could go into one of these blocks but I like the node output format better. Not really a memetracker question but thought you might be able to help with some advice.

Thanks,

Jerry

kyle_mathews’s picture

kyle_mathews commented

Glad to hear you got memetracker running :) The problem with issue queues is you only hear about problems. . . so it's nice to hear something on the positive side for a change.

If you know how to code PHP doing what you ask wouldn't be too hard. The memes are cached in the database. The memebrowsing page just grabs the cache of memes and then formats them for display. You could write a block that would do essentially the same thing -- grab the cached info from the database and then format it for display in a block. I've been planning on doing this. . . but time is extremely limited these days sadly enough :(

manogolf’s picture

manogolf commented

Kyle,

Not much of a coder but what you suggest does not sound terribly difficult.

If anyone reading this thread can do this for me I will happily negotiate compensation and in turn donate back the finished product. I'll check back for responses.

Jerry