An error occurred during link creation

[peter.marius]

I'm using ver 1.4.6.2 after upgrade from 1.3.7.

I want add some more links to my "blocklink" module and I get this error:

An error occurred during link creation.

[peter.marius]

nobody?

10Q!

[FaTedev]

OK we also had this problem but it got put on the backburner while we fixed bigger issues.

 

The primary fail area of this linkblock occurs in blocklink.php under function addLink()

 

The URL registration fails the rest of the script. After some DB poking I found while the code leaves the table to assign a new ID value:

 

INSERT INTO '._DB_PREFIX_.'blocklink VALUES (NULL, < however under the blocklink table the ID itself is a regular INT!

 

How to fix:

 

Log into your database and navigate to the `blocklink` table. View structure and alter `ID_blocklink` to auto_incremement value or:

 

ALTER TABLE `YOURPREFIX_blocklink` CHANGE `id_blocklink` `id_blocklink` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT

 

Changing `YOURPREFIX_blocklink` to the atual name of your table.

 

Now the script can properly assign the link an ID and can insert the language texts in blocklink_lang.

 

[agenceweb74]

Thanks for sharing, we also met this problem.

[(\)icholas]

No auto-increment on mine either.  Currently i'm at 1.5.6.0 on a store that started on 1.3.  Funny thing is I added links just fine at a lower version.  I wonder how the update script managed to drop Auto-Increment?  That or incrementing was being handled in code; but that would be ridiculous!  Anyways thanks for pointing me to a quick resolution.

Edited January 29, 2015 by (\)icholas (see edit history)