Stamp collection add-on:: Error in Moodle 1.6.1

Stamp collection add-on:: Error in Moodle 1.6.1

by Savanah Fahrney-Day -
Number of replies: 4

I can't get this to work. I have installed several different modules and dont' usually have a problem, but this keeps telling me:

(mysql): INSERT INTO mdl_log_display VALUES ('stampcoll', 'view', 'stampcoll', 'name')  


1136: Column count doesn't match value count at row 1

         
      
   


Error

I receive seveal of those error messages. Can someone help please?

I have MySQL version 4.0.25-standard and Moodle 1.6.1

Thanks,

Savanah

 

Average of ratings: -
In reply to Savanah Fahrney-Day

Re: New module: Stamp Collection

by Vitor Gonçalves -

If you change the lines: (in db/mysql.sql)

INSERT INTO prefix_log_display VALUES...

to

INSERT INTO prefix_log_display (module, action, mtable, field) VALUES...

I think the problem will disappear...

In reply to Savanah Fahrney-Day

Re: New module: Stamp Collection

by Alistair McQuade -
Hi Savanah,

I got the same errors: (mysql): INSERT INTO mdl_log_display VALUES ('stampcoll', 'view', 'stampcoll', 'name')

They stem from the mysql file which was missing the 'ID' field. To get over this uninstall the stampcoll module and then try replacing the file mod/stampcoll/db/mysql.txt with the file mysql.txt in the attached zip.

One further problem I found as a 'parametre = 0' error when I clicked on the 'stamp collections' menu hyperlink. If you get this, replace the mod/stampcoll/index.php file with the attached index.php file too. This worked for me and I also have the same set up as you.

Al
In reply to Alistair McQuade

Re: New module: Stamp Collection

by Savanah Fahrney-Day -

Okay. I changed those files and now I'm getting different error messages.

mysql): INSERT INTO mdl_log_display VALUES ('stampcoll', 'view', 'stampcoll', 'name')  


1136: Column count doesn't match value count at row 1

                  

Error

I'm recieving several of those messages now. Any ideas?!? I would really love to be able to utilize this tool, if I can ever get it to work.

In reply to Savanah Fahrney-Day

Re: New module: Stamp Collection

by Alistair McQuade -
1) make sure you have deleted all the tables and the fields in your database before you re-load. I looked at:
http://institute.touchofenchantment.com/moodle/admin/index.php

The errors reported are telling you that the tables are already set up.

2) the error is the same as before which could indicate that you have not actually swapped the mysql file: here is a statement from the original mysql file:

I changed this in the new file to:


see the additional field in red? this should not return the error that you have posted.


Al