Gallery Bug after normal using since months (...) Need help

[edy]

Well here is the problem

I'm using my gallery since years. i's installed the last version moded by stramm and everything was working perfectly well till I decided to Undo the watermark effect.
Istead of Saving the changed I did, I clicked on "Restor". Then I realized that this wasn't actually what I wanted to I get back and clickt "Save changes" (In Configuration of corse).
And then suddenly everything got white. And the gallery dissapeared... I tried to enable debug mode via phpmyadmin, and its still not working..

here is the link: http://spearsintentions.com/Photos/

Thanx =)

Best regards
edy

[Nibbler]

Don't delete the classic theme. Re-upload it.

[edy]

Don't delete the classic theme. Re-upload it.

Thanx for answering that fast. I reuploaded the Classic theme and now it says that there was an critical error:

http://spearsintentions.com/Photos/

[Nibbler]

Delete the 'users online' plugin and reinstall it once your gallery is working again.

[edy]

Thanx for answering that fast. I reuploaded the Classic theme and now it says that there was an critical error:

http://spearsintentions.com/Photos/

Upadate:
Here is the error:

While executing query "DELETE FROM cpg14x_mod_online WHERE last_action < NOW() - INTERVAL  MINUTE" on 0

mySQL error: 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 '' at line 1


Fichier: /home/spearsin/public_html/Photos/include/functions.inc.php - Ligne: 248 

Infos:
USER:
------------------
Array
(
    [ID] => af9417fc94cd07f018703e13ffbf60f7
    [am] => 1
    [lang] => french
    [liv] => Array
        (
           

• => 20415
              [1] => 18569
              [2] => 18571
              [3] => 15050
              [4] => 15048
          )
  
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 0
      [user_name] => Guest
      [groups] => Array
          (
             
• => 3
          )
  
      [group_quota] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 0
      [can_post_comments] => 0
      [can_upload_pictures] => 0
      [can_create_albums] => 0
      [pub_upl_need_approval] => 1
      [priv_upl_need_approval] => 1
      [upload_form_config] => 0
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [custom_user_upload] => 0
      [disk_max] => 0
      [disk_min] => 0
      [ufc_max] => 0
      [ufc_min] => 0
      [has_admin_access] => 0
      [group_name] => Guests
      [can_see_all_albums] => 0
      [group_id] => 3
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
      [1] => select * from cpg14x_plugins order by priority asc; (0s)
      [2] => delete from `spearsin_Photos`.cpg14x_sessions where time<1233502216 and remember=0; (0s)
      [3] => delete from `spearsin_Photos`.cpg14x_sessions where time<1232296216; (0s)
      [4] => select user_id from `spearsin_Photos`.cpg14x_sessions where session_id = '2b73ae28d3ddcba0330dca459cf692e7' (0s)
      [5] => select user_id as id, user_password as password from `spearsin_Photos`.cpg14x_users where user_id=0 (0s)
      [6] => 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 cpg14x_usergroups WHERE group_id in (3) (0s)
      [7] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 3 (0s)
      [8] => update `spearsin_Photos`.cpg14x_sessions set time='1233505816' where session_id = '2b73ae28d3ddcba0330dca459cf692e7' (0.004s)
      [9] => DELETE FROM cpg14x_mod_online WHERE last_action < NOW() - INTERVAL  MINUTE (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  Page generated in 0.195 seconds - 10 queries in 0.004 seconds - Album set : ; Meta set: ;
  
  
  
  
  
  
  
  
  
  
  
  
  
  I Don't know what to do 

[Joachim Müller]

Delete the plugin and the error should go away. To get rid of the plugin, use your FTP app and delete the folder that correspdonds to http://spearsintentions.com/Photos/plugins/onlinestats/. Then use phpMyAdmin, browse the table "cpg14x_plugins", find the entry that corresponds to the "Who is online" plugin and delete that line. Finally, delete the table cpg14x_mod_online.
If you're not sure what you're doing, backup your database first before performing the database editing! Making a mistake there will have a very serious impact and can not be undone.

In the future, don't post debug_output unless requested. The entire issue is not related to initial install, so I'm moving this thread accordingly.

[edy]

thank you very much for your help