Please! MySQL 5!!!

[emvader]

I pray you! Please make as fast as it is available the support of MySQL 5 DB! plz!!!

[Nibbler]

Support for MySQL 5 already exists. What is your issue ?

[emvader]

It can't be because I upgrade from my old DB 3.23... which was connected with 1.32 to 1.43 with 5x MySQL! And when adding files there is an "Error while processing the database query"... I've tried everything.... nothing helps! Plz! Help!

Some more info in short: i've made a dump of my old DB and exported after new installation, then ran update.php, it changed and added smth... but still I can't add anything...


P.S. And 1 more question: why 1.4.3 goes without any mysqli_ function inside??!

[Nibbler]

Enabling debug mode and posting the mysql error message that you get would help, as would searching the board before posting. Coppermine uses only the mysql_ functions for now which will work fine with mysql 5.

[emvader]

Here is the code after trying adding a file with "Batch file add":

Code Select Expand

USER:
------------------
Array
(
    [ID] => xxxxxxxxx
    [am] => 1
    [lang] => russian
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => emvader
    [groups] => Array
        (
            [0] => 1
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM kino_gal_filetypes; (0.001s)
    [1] => select * from kino_gal_plugins order by priority asc; (0.001s)
    [2] => delete from `kino_gal`.kino_gal_sessions where time<1139157990 and remember=0; (0.001s)
    [3] => delete from `kino_gal`.kino_gal_sessions where time<1137951990; (0s)
    [4] => select user_id from `kino_gal`.kino_gal_sessions where session_id=md5("xxxxxxxxx"); (0s)
    [5] => select user_id as id, user_password as password from `kino_gal`.kino_gal_users where user_id=1 (0s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `kino_gal`.kino_gal_users AS u INNER JOIN `kino_gal`.kino_gal_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `kino_gal`.kino_gal_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
    [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM kino_gal_usergroups WHERE group_id in (1) (0.001s)
    [9] => SELECT group_name FROM  kino_gal_usergroups WHERE group_id= 1 (0s)
    [10] => update `kino_gal`.kino_gal_sessions set time='1139161590' where session_id=md5('xxxxxxxxx'); (0s)
    [11] => SELECT user_favpics FROM kino_gal_favpics WHERE user_id = 1 (0.001s)
    [12] => DELETE FROM kino_gal_banned WHERE expiry < '2006-02-05 17:46:31' (0s)
    [13] => SELECT * FROM kino_gal_banned WHERE (ip_addr='10.20.121.12' OR ip_addr='10.20.121.12' OR user_id=1) AND brute_force=0 (0s)
    [14] => SELECT aid, title FROM kino_gal_albums WHERE 1 (0.001s)
    [15] => SELECT COUNT(*) FROM kino_gal_pictures WHERE approved = 'NO' (0.001s)
)

==========================
GET :
------------------
Array
(
    [insert] => 1
)

==========================
POST :
------------------
Array
(
    [d0000] => 30
    [album_lb_id_i0000] => d0000
    [picfile_i0000] => LT1wb3N0ZXJzPS0vLT1VbmRlcndvcmxkIC0gRXZvbHV0aW9uPS0vdW5kZXJ3b3JsZDJfMS5qcGc=
    [album_lb_id_i0001] => d0000
    [picfile_i0001] => LT1wb3N0ZXJzPS0vLT1VbmRlcndvcmxkIC0gRXZvbHV0aW9uPS0vdW5kZXJ3b3JsZDJfMi5qcGc=
    [album_lb_id_i0002] => d0000
    [picfile_i0002] => LT1wb3N0ZXJzPS0vLT1VbmRlcndvcmxkIC0gRXZvbHV0aW9uPS0vdW5kZXJ3b3JsZDJfMy5qcGc=
    [album_lb_id_i0003] => d0000
    [picfile_i0003] => LT1wb3N0ZXJzPS0vLT1VbmRlcndvcmxkIC0gRXZvbHV0aW9uPS0vdW5kZXJ3b3JsZDJfNC5qcGc=
    [pics] => Array
        (
            [0] => i0004
        )

    [album_lb_id_i0004] => d0000
    [picfile_i0004] => LT1wb3N0ZXJzPS0vLT1VbmRlcndvcmxkIC0gRXZvbHV0aW9uPS0vdW5kZXJ3b3JsZDJfNS5qcGc=
    [insert] => Р'СЃС,авиС,СЊ выбранные С,,айлы
)

==========================
VERSION INFO :
------------------
PHP version: 5.1.2 - OK
------------------
mySQL version: 5.0.16-nt
------------------
Coppermine version: 1.4.3(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support: 1
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support:
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 4.1.7
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .;C:\php5\pear | .;C:\php5\pear
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | emvader@gagarinclub.ru | emvader@gagarinclub.ru
sendmail_path | no value | no value
SMTP | smtp.gagarinclub.ru | smtp.gagarinclub.ru
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 1205M | 1205M
post_max_size | 8M | 8M
==========================
Page generated in 0.132 seconds - 16 queries in 0.007 seconds - Album set : ; Meta set: ;

Code Select Expand

\include\themes.inc.php

    * Notice line 1340: Undefined index: home_title
    * Notice line 1341: Undefined index: home_lnk
    * Notice line 1349: Undefined index: my_prof_title
    * Notice line 1364: Undefined index: login_title
    * Notice line 1367: Undefined index: logout_title
    * Notice line 1389: Undefined index: lastup_title
    * Notice line 1392: Undefined index: lastcom_title
    * Notice line 1395: Undefined index: topn_title
    * Notice line 1398: Undefined index: toprated_title
    * Notice line 1401: Undefined index: fav_title
    * Notice line 1404: Undefined index: search_title
    * Notice line 1444: Undefined index: upl_app_title
    * Notice line 1446: Undefined index: admin_title
    * Notice line 1447: Undefined index: admin_lnk
    * Notice line 1448: Undefined index: albums_title
    * Notice line 1450: Undefined index: categories_title
    * Notice line 1452: Undefined index: users_title
    * Notice line 1454: Undefined index: groups_title
    * Notice line 1456: Undefined index: comments_title
    * Notice line 1458: Undefined index: searchnew_title
    * Notice line 1460: Undefined index: my_prof_title
    * Notice line 1462: Undefined index: util_title
    * Notice line 1464: Undefined index: ban_title
    * Notice line 1466: Undefined index: db_ecard_title
    * Notice line 1468: Undefined index: pictures_title
    * Notice line 1469: Undefined index: pictures_lnk
    * Notice line 1471: Undefined index: documentation_lnk
    * Notice line 1472: Undefined index: documentation_lnk

\searchnew.php

    * Notice line 443: Undefined index: result_icon
    * Notice line 465: Undefined variable: edit_pics_content
    * Notice line 466: Undefined index: edit_pics
    * Notice line 467: Undefined index: edit_properties
    * Notice line 468: Undefined index: view_thumbs

[Nibbler]

Please do as suggested and post the mysql error message you receive, not the debug output.

[emvader]

What do you mean under "mysql error message"?

In server Logs i can't find anything (I'm looking at it througn MySQL Administrator). For today there is only:

Code Select Expand

060205 11:24:27  InnoDB: Started; log sequence number 0 563588
060205 11:24:28 [Note] D:\Server\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.16-nt'  socket: ''  port: 3306  Official MySQL binary

May be you tell me, where shall I look for the Log...

And as for gallery, it does not return any message and there is no picture: neither OK, neither DP, neither PB, nor NA... or if there just "image not found" icon-after clicking on it: "There was an error while processing the database query"!

[Nibbler]

If you have debug mode enabled then you get a mysql error message instead of 'There was an error while processing the database query'

[emvader]

Got it!

Code Select Expand

While executing query "INSERT INTO kino_gal_pictures (aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip, position) VALUES ('30', '-=posters=-/-=Underworld - Evolution=-/', 'underworld2_5.jpg', '482156', '523623', '1500', '2000', '1139163804', '1', 'emvader','', '', '', 'YES', '', '', '', '', '', '', '0')" on 0

mySQL error: Field 'pid' doesn't have a default value

[Nibbler]

Ensure that the pid field in the table is set to auto_increment using phpmyadmin. Perhaps they have been lost during your export/import.

[emvader]

OMG!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! You're the second after God! SOLVED!!!!!!!! Thx a lot! The biggest thx in the World!!!

But plz one more little question: some menu strings as "Config" e.g. are not displayed...

It's because gallery lost the parametr of English as default lang if in translation there is no such point

[Joachim Müller]

you'll have to:
1) Upgrade your custom theme as suggested in the upgrade section of the docs
2) respect the "one issue per thread" policy in the future. You agreed to respect it when signing up.

Marking this thread as "solved" and locking it. If you still have issues after having read the docs and after searching the board, post a new thread on the proper board.