Augustin_Zidek

The solution for you problem might be here: https://www.ads-software.com/support/topic/mysql-errors-5?replies=6

Hi jazmo_,

thanks a lot, this worked! My life is much, much better now.

Manual for other desperate users:
1) Go to wp-content/plugins/weekly-class-schedule/includes/WcsDb.php and change:

UNIQUE KEY class_name (class_name) --> UNIQUE KEY class_name (class_name(40))
UNIQUE KEY classroom_name (classroom_name) --> UNIQUE KEY classroom_name (classroom_name(40))
UNIQUE KEY instructor_name (instructor_name) --> UNIQUE KEY instructor_name (instructor_name)

2) Change all occurrences of varchar(256) to varchar(255)

3) De-activate the plugin

4) Go to phpMyAdmin and drop (delete) all databases that have wcs* of ws* and either class, classroom, schedule or instructor in their name.

5) Re-activate the plugin.

Hi,
I got exactly the same error.

I had followed your advice and modified the file includes/WcsDb.php (all three occurrences).

However, when I try to add a new classroom or a new instructor, I still get the error “Failed to add item to the database“. What am I doing wrong?

Thanks in advance.

Works, thanks. Marking as resolved.

Marry Christmas.

Update: The problem with file size has been already fixed (that was server problem). However, the upload page still says:

Based on your server memory limit you should not upload images larger then 153 x 115 (0.0 MP).

I updated to version 4.5.1 today, and the upload works just great! Thank you!

Hi Opajaap,

sorry for not responding for such a long time. I would like to thank you this feature and your immediate reaction!

There is one thing I would still like to suggest: When uploading single photos, once you select a photo it is added into a list under the file-input box. Would this be possible also with the multiple file upload? So that once you select multiple photos the list of them would be added under the multiple-file-input box.

Thank you. Should I expect a new version adding this feature next week? ??

Hi. I did some research on this topic and I have found this, maybe it can help:
https://rakaz.nl/2009/08/uploading-multiple-files-using-html5.html

Note: You probably noticed the brackets I used in the name of the input element. This is not a requirement of the HTML5 specification in any way, but it is a requirement of the PHP scripting language I use on the server. If you add the brackets to the name PHP will construct an array of the uploaded files on the server. If you would leave off the brackets it would process the files in order and only provide the last file to your script. For more information about processing multiple uploaded files see the PHP manual.

And the php article concerning this topic:

https://www.php.net/manual/en/features.file-upload.multiple.php