There was an error while processing a database query ....

[Prisoner_24601]

Yes, I know: standard error .

I'd get this error when trying to click the "JUpload Configuration" button under Plugins in the Plugin Manager.  I tried under multiple Admin accounts and themes and then I decided to DEBUG.

This button runs the following query:

Code Select Expand

CREATE TABLE IF NOT EXISTS cpg14x_jupload_session (
  session_id varchar(40) NOT NULL,
  jupload_session_id varchar(40) NOT NULL,
  ip tinytext    NOT NULL,
  valid_until datetime NOT NULL,
  user_name varchar(25) NOT NULL,
  user_data text NOT NULL,
  PRIMARY KEY  (session_id, jupload_session_id)
) TYPE=MyISAM COMMENT='Used to store JUpload sessions (used only for upload through the plugin, when sessionManagement configuration parameter is JUpload)';

The error in DEBUG said that the COMMENT was too long.

I manually ran the SQL query through phpMyAdmin, but set all the varchar amounts to 255 and deleted the COMMENT line.  I tried the "JUpload Configuration" button again and it worked just fine.

Dunno if anyone else is havening this problem or if it's just me (my configuration).  I searched and didn't see anything.

My compliments to etienne_sf on a beautiful plugin.  I'm going to get a lot of use out of it!

==========

My current config:
* Coppermine 1.4.19
* PHP 5.1.1
* MySQL client version: 4.1.7
* IIS  (Windows NT MIRAGE 5.2 build 3790)
* JUpload 3.2.4

[etienne_sf]

Hi,

Thanks .. and have a big use if it !



  You're the first to report this error.


It's the first time I see an application crash, because the comment is too long !!!!



I changed it to Used to store JUpload sessions (see sessionManagement JUpload configuration parameter).

Can you check it on your system ?

Etienne

[MarkRH]

I'm trying out the program locally on my PC.. actually I'm evaluate Coppermine Gallery itself locally before setting it up on hosting service.  Anyway, I get "Critical error There was an error while processing a database query" when clicking on the Configuration Button. 

Same issue it would appear:

Code Select Expand


While executing query "
CREATE TABLE IF NOT EXISTS cpg14x_jupload_session (
  session_id varchar(40) NOT NULL,
  jupload_session_id varchar(40) NOT NULL,
  ip tinytext    NOT NULL,
  valid_until datetime NOT NULL,
  user_name varchar(25) NOT NULL,
  user_data text NOT NULL,
  PRIMARY KEY  (session_id, jupload_session_id)
) TYPE=MyISAM COMMENT='Used to store JUpload sessions (see sessionManagement JUpload configuration parameter)';
" on 0

mySQL error: Too long comment for table 'cpg14x_jupload_session'


I ran it locally using SQLYog, and it did create the table with 2 warnings and looks like it truncated the comment.  It's table creation looks like:

Code Select Expand


CREATE TABLE `cpg14x_jupload_session` (                                                                       
                          `session_id` varchar(40) NOT NULL,                                                                           
                          `jupload_session_id` varchar(40) NOT NULL,                                                                   
                          `ip` tinytext NOT NULL,                                                                                     
                          `valid_until` datetime NOT NULL,                                                                             
                          `user_name` varchar(25) NOT NULL,                                                                           
                          `user_data` text NOT NULL,                                                                                   
                          PRIMARY KEY  (`session_id`,`jupload_session_id`)                                                             
                        ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store JUpload sessions (see sessionManagement JUploa';


I'm running MySQL version 5.0.51b-community-nt

On further examination: http://dev.mysql.com/doc/refman/5.0/en/create-table.html
Shows the comment can be up to 60 characters.

[etienne_sf]

Right!

  On my database, the comment is :
Used to store JUpload sessions (used only for upload through

Which is also 61 characters long.

  Do you have anywhere a config that tell MySql to throw an error when a warning occurs ?


You can update the plugins/jupload/include/session.inc.php file, and change or remove the comment around the line 91.


Etienne