After upgrading from 1.3.4 to 1.4.9 using Fantastico, I tried to upload pictures, the pictures seemed to upload, but when tried to place the pictures in albums, I got the following error messege:
There was an error while processing a database query
And when I tried to change the album, I got the following error message:
Upload Failure - './albums/edit/'
May I know how to fix this problem?
Thanks
Enable debug mode and post the mysql error message that you get when you try to upload. Don't use the back button while uploading files.
Thanks for your reply. Following is the message I notice when I clicked to upload pics. This message appreared at the bottom:
***************
/include/logger.inc.php
* Notice line 172: Undefined index: log_mode
* Notice line 164: Undefined index: log_mode
/include/init.inc.php
* Notice line 223: Undefined index: enable_plugins
* Notice line 228: Undefined index: bridge_enable
/include/functions.inc.php
* Notice line 395: Undefined index: time_offset
* Notice line 395: Undefined index: time_offset
/include/themes.inc.php
* Notice line 1188: Undefined index: custom_header_path
* Notice line 1336: Undefined index: home_target
* Notice line 1374: Undefined index: custom_lnk_url
* Notice line 1382: Undefined index: custom_lnk_url
* Notice line 1383: Undefined index: custom_lnk_name
* Notice line 1384: Undefined index: custom_lnk_name
* Notice line 1220: Undefined index: custom_footer_path
/upload.php
* Notice line 269: Undefined offset: 2
* Notice line 275: Undefined offset: 3
* Notice line 275: Undefined offset: 4
*************
After I uploaded, the message came:
***********
/include/logger.inc.php
* Notice line 172: Undefined index: log_mode
/include/init.inc.php
* Notice line 223: Undefined index: enable_plugins
* Notice line 228: Undefined index: bridge_enable
/include/functions.inc.php
* Notice line 395: Undefined index: time_offset
* Notice line 395: Undefined index: time_offset
/upload.php
* Notice line 1968: Undefined variable: file_failure_array
* Notice line 1969: Undefined variable: URI_failure_array
* Notice line 1970: Undefined variable: zip_failure_array
/include/themes.inc.php
* Notice line 1188: Undefined index: custom_header_path
* Notice line 1336: Undefined index: home_target
* Notice line 1374: Undefined index: custom_lnk_url
* Notice line 1382: Undefined index: custom_lnk_url
* Notice line 1383: Undefined index: custom_lnk_name
* Notice line 1384: Undefined index: custom_lnk_name
* Notice line 1220: Undefined index: custom_footer_path
************
On the page where I choose Album for Pics:
*********
/include/logger.inc.php
* Notice line 172: Undefined index: log_mode
/include/init.inc.php
* Notice line 223: Undefined index: enable_plugins
* Notice line 228: Undefined index: bridge_enable
/include/functions.inc.php
* Notice line 395: Undefined index: time_offset
* Notice line 395: Undefined index: time_offset
* Notice line 2649: Undefined index: enable_help
* Notice line 2650: Undefined index: enable_help
* Notice line 2672: Undefined variable: i
/include/picmgmt.inc.php
* Notice line 170: Undefined variable: imageinfo
* Notice line 205: Undefined index: OS
/include/themes.inc.php
* Notice line 1188: Undefined index: custom_header_path
* Notice line 1336: Undefined index: home_target
* Notice line 1374: Undefined index: custom_lnk_url
* Notice line 1382: Undefined index: custom_lnk_url
* Notice line 1383: Undefined index: custom_lnk_name
* Notice line 1384: Undefined index: custom_lnk_name
* Notice line 1220: Undefined index: custom_footer_path
************
And then...
There was an error while processing a database query.
While executing query "INSERT INTO cpg_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 ('20', 'userpics/', 'cowasaki~2.gif', '178556', '273821', '375', '281', '1161237714', '1', 'Admin','', '', '', 'YES', '', '', '', '', '202.125.143.67', '202.125.143.67', '0')" on 0
mySQL error: Unknown column 'position' in 'field list'
File: /home/apni/public_html/fungama/include/functions.inc.php - Line: 249
This is what you've got from Autoinstaller scripts ,
DO NOT use fantastico or any other autoinstaller scripts ,
Instead Download the most recent version (currently 1.4.9) from here (http://sourceforge.net/project/showfiles.php?group_id=89658) and upgrade your CPG as suggested under documentation Manually
- In your case running update.php may help you
Thanks. Noted. I am at it now.
Will come back after I finish. Thanks again.
I have fixed this error by running update.php.
Thanks
But now I noticed View counter does not change.
I uploaded a file, clicked it, then noticed it did not change its view counter to 1
May I know what should be done?
Admin views will not count, logout and try ...