SmartCJ Support Forum

Code: Select all

Updating settings (3.417181968689, 0.84572196006775) 
Updating DB fields (3.7417771816254, 0.3245952129364) 
Updating DB indexes (3.7461359500885, 0.0043587684631348) 
Updating rotation rating (3.7540349960327, 0.0078990459442139) 
Updating stats indexes (3.772402048111, 0.018367052078247) 
Checking fields (4.0692460536957, 0.29684400558472) 
Check gallery dates (4.1257951259613, 0.056549072265625) 
Updating countries table (4.3066740036011, 0.18087887763977) 
Adding extra thumb field into rot_thumbs
Updating stat indexes (5.4822850227356, 1.1756110191345) 
Mysql error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL' at line 1 (ALTER TABLE `rot_gallery_info` CHANGE `source_url` `source_url` VARCHAR(512) CHARACTER SET utf8 COLLATE  NOT NULL)  (5.6240501403809, 0.14176511764526) 

Code: Select all

mysql> SHOW FULL COLUMNS FROM rot_gallery_info;
+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
| Field                   | Type                                                                                                                                        | Collation       | Null | Key | Default | Extra          | Privileges                      | Comment |
+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
| gallery_id              | int(10) unsigned                                                                                                                            | NULL            | NO   | PRI | NULL    | auto_increment | select,insert,update,references |         |
| gallery_type            | tinyint(4) unsigned                                                                                                                         | NULL            | NO   | MUL | 0       |                | select,insert,update,references |         |
| url                     | varchar(255)                                                                                                                                | utf8_bin        | NO   | MUL | NULL    |                | select,insert,update,references |         |
| source_url              | varchar(255)                                                                                                                                | utf8_general_ci | NO   | MUL | NULL    |                | select,insert,update,references |         |
| sponsor_id              | int(10) unsigned                                                                                                                            | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| content_count           | mediumint(8) unsigned                                                                                                                       | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| content_type            | tinyint(3) unsigned                                                                                                                         | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| duration                | smallint(5) unsigned                                                                                                                        | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| added_date              | datetime                                                                                                                                    | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| activation_date         | datetime                                                                                                                                    | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| custom_gallery          | enum('yes','no')                                                                                                                            | utf8_general_ci | NO   | MUL | no      |                | select,insert,update,references |         |
| embed_template          | varchar(50)                                                                                                                                 | utf8_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
| embed_code              | text                                                                                                                                        | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |
| flv_url                 | varchar(255)                                                                                                                                | utf8_general_ci | NO   | MUL | NULL    |                | select,insert,update,references |         |
| flv_size_x              | smallint(5) unsigned                                                                                                                        | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| flv_size_y              | smallint(5) unsigned                                                                                                                        | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| flv_thumb_url           | varchar(255)                                                                                                                                | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |
| video_preview_url       | varchar(255)                                                                                                                                | utf8_general_ci | YES  |     | NULL    |                | select,insert,update,references |         |
| content_server_id       | smallint(5) unsigned                                                                                                                        | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| content_crop_profile_id | smallint(5) unsigned                                                                                                                        | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| content_gallery_text    | varchar(1024)                                                                                                                               | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |
| content_thumbs          | text                                                                                                                                        | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |
| content_grab_options    | varchar(1024)                                                                                                                               | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |
| gallery_total_shows     | int(10) unsigned                                                                                                                            | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| rating                  | decimal(6,4)                                                                                                                                | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| crop_profile_id         | smallint(5) unsigned                                                                                                                        | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| thumbs                  | varchar(8192)                                                                                                                               | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |
| grab_options            | mediumtext                                                                                                                                  | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |
| gallery_owner           | varchar(50)                                                                                                                                 | utf8_general_ci | NO   |     | NULL    |                | select,insert,update,references |         |
| last_checked            | int(10) unsigned                                                                                                                            | NULL            | NO   |     | NULL    |                | select,insert,update,references |         |
| gallery_status          | enum('to_grab','processing','grab_error','preload','active','pool','old','to_delete','to_regrab','inactive','banned','off_till_activation') | utf8_general_ci | NO   | MUL | to_grab |                | select,insert,update,references |         |
+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------+-----------------+------+-----+---------+----------------+---------------------------------+---------+
31 rows in set (0.00 sec)