Errors in Status Report

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

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?

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?

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:

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

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.

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

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.

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.

Kyle,

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

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

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

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

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

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.

Have you had any time for testing?

Jerry

Not yet. . . hopefully on Saturday?

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

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 :(

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