Everytime when click on a linked phrase getting the following:

user warning: Table 'kopsite.freelinking' doesn't exist query: SELECT hash FROM freelinking WHERE phrase = 'Поисковая фраза' in C:\wamp\www\kopsite\sites\all\modules\freelinking\freelinking.module on line 510.
CommentFileSizeAuthor
#1 freelinking 6.x-1.6 complete.tar_.gz14.69 KBwopi

Comments

wopi’s picture

StatusFileSize
new14.69 KB

I have workaround for you. Maybe this is also a clue for a definitive solution.

My workaround: install a complete version of freelinking 6.x-1.6, see attachment.
My version has some extra files that (appearently) are necessary to create the database table that is used by freelinking. These files are missing in the 6.x-1.6 package that you can download from drupal.org.

In the status report of your site you will see that there is an update for your freelinking module. You have to ignore it, because (appearently) the 6.x-1.10 package on drupal.org is not complete either.

I tried to fix this for myself by adding the missing files manually to the 6.1-x.10 package, but that was not a good idea. This manual package does not work and after that it is impossible to return to the previous version (impossible means: I did not succeed in degrading the module - there must be some residue in the database, but I can't find it). Another strange thing: at first the module was grouped under "input filters", later on I found it under "other".

Please notify me when there is a complete 6.x-1.10 package. And if there is a solution to get rid of the residue in my database, please tell me: the site still works, but I have to start with a fresh database in order to get freelinking working ...

PS
In the download history I see that we are not the only users who downloaded this module. Are others using it succesfully and should we install it via another procedure or so?

bjsomers’s picture

I have the same issue, but the attached solution doesn't seem to be in the right format. When I unwrap it, the file type is unreadable by my machine. Please advise.

jshoor’s picture

I received this warning message as well. After a bit of troubleshooting, I realized that the table had never been created properly during the install. This was due to a syntax error in the create table statement. Correcting the statement, uninstalling the module, and reinstalling it, fixed the issue.
In freelinking.install line 14, the keyword TYPE is deprecated and should be replaced by ENGINE. Therefore, the line should read:
ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;');

wunderbard’s picture

jshoor is completely right. I do not understand why the most recent recommended release of Freelinking for Drupal 6, being 6.x-1.10, has not seen a debugged follow-up.

Grayside’s picture

Freelinking predates the schema system that supports prefixes. Note that the issue was created on 1.0.

If someone cares to implement a patch to correct the freelinking.install, I will apply it and release 1.11. I would prefer to see a properly done table schema to a simple line fix.

What little time I have on this module (and it's been a scant few hours in the last year) has been concentrated on Freelinking 3.x. I have never used Freelinking 1.x except to test bugfixes, and would love a co-maintainer to look after 6.x-1.x and (probably) a 7.x-1.x.

juampynr’s picture

Status: Active » Postponed (maintainer needs more info)

Does anyone still needs support for this issue? Please do let me know with an update status if needed.

juampynr’s picture

Status: Postponed (maintainer needs more info) » Closed (won't fix)

Closing.