There was an error while processing a database query

[Invalid ID]

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

[Nibbler]

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.

[Invalid ID]

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...

Code Select Expand

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'

[Invalid ID]

File: /home/apni/public_html/fungama/include/functions.inc.php - Line: 249

[Sami]

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 and upgrade your CPG as suggested under documentation Manually

- In your case running update.php may help you

[Invalid ID]

Thanks. Noted. I am at it now.

Will come back after I finish. Thanks again.

[Invalid ID]

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?

[Sami]

Admin views will not count, logout and try ...