Hi,
there is an issue with my version of viewslideshow. I'm unable to create a slideshow of images at the top of any of my pages using 'views', an example of the error code is generated below:

Can anyone advise me what the problem might be?
Thanks

user warning: Data too long for column 'location' at row 1 query: UPDATE locales_source SET location = 'sites/all/modules/views_slideshow/contrib/views_slideshow_singleframe/views_slideshow.js; sites/all/modules/views_slideshow/contrib/views_slideshow_thumbnailhover/views_slideshow.js; sites/all/modules/views_slideshow/contrib/views_slideshow_cycle/views_sl; sites/all/modules/views_slideshow/contrib/views_slideshow_cycle/views_slideshow_cycle.js' WHERE lid = 5 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\excel-intranet\includes\locale.inc on line 1748.
user warning: Data too long for column 'location' at row 1 query: UPDATE locales_source SET location = 'sites/all/modules/views_slideshow/contrib/views_slideshow_cycle/views_slideshow_cycle.js; sites/all/modules/views_slideshow/contrib/views_slideshow_singleframe/views_slideshow.js; sites/all/modules/views_slideshow/contrib/views_slideshow_thumbnailhover/vi; sites/all/modules/views_slideshow/contrib/views_slideshow_thumbnailhover/views_slideshow.js' WHERE lid = 32 in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\excel-intranet\includes\locale.inc on line 1748.

Comments

roseryn’s picture

roseryn commented
Version: 6.x-3.x-dev » 6.x-2.3

Hello all,
I've received a warning similar to this as well. Is there a way to fix it without going directly into the database?

Thanks!

artworker’s picture

artworker commented

@reseryn
Hi, yes I believe there is, this error occurs when there is insufficient memory allocation for your data base server.

You could probably increase the memory allocation yourself in your php server settings or contact your host company to do this for you. You can also amend the php.ini file which controls the amount of memory the database uses.

There is advice on this in 'Community Documentation':

Increase php memory limit

redndahead’s picture

redndahead commented
Status: Active » Closed (won't fix)

Yeah I think you need to fix your database. My guess is it's putting wrong settings in there because I'm getting an error instead of a correct return value.