Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4260
Latest: Verrick
New This Month: 3
New This Week: 0
New Today: 0
Stats
Total Posts: 43301
Total Topics: 7525
Most Online Today: 102
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 78
Total: 78

Author Topic: Can't DROP 'id_member'; check that column/key exists Datei:  (Read 1097 times)

0 Members and 1 Guest are viewing this topic.

Offline Michel68

  • SMF Gallery Pro Customer
  • Full Member
  • *****
  • Posts: 165
    • View Profile
After I am trying to reinstall SMFGallery10beta2.zip I am getting

Can't DROP 'id_member'; check that column/key exists
File: /homepages/xx/Packages/temp/galleryinstall2.0.x.php
Line: 1072

Line 1072
$smcFunc['db_query']('', "ALTER TABLE {db_prefix}gallery_log_mark_view DROP INDEX id_member");

Offline Michel68

  • SMF Gallery Pro Customer
  • Full Member
  • *****
  • Posts: 165
    • View Profile
Re: Can't DROP 'id_member'; check that column/key exists Datei:
« Reply #1 on: March 30, 2024, 08:33:34 am »
I think I found the problem. After restoring the forum, SQL dump and HTML pages I encountered the problem again. I activated the SSL certificate for the domain, so that the forum has now been converted from HTTP to HTTPS. All the references in the database probably point to HTTP. I could no longer edit images using the internal image editing program; a blank page came up or nothing happened.

Is that possible ?

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16455
    • View Profile
Re: Can't DROP 'id_member'; check that column/key exists Datei:
« Reply #2 on: March 30, 2024, 09:58:35 am »
I will look into your first post
But for your second. Run this tool and update any url that is http:// to https://
https://wiki.simplemachines.org/smf/Repair_settings.php

Also please do that in the gallery settings as well.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/
Like Like x 1 View List

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16455
    • View Profile
Re: Can't DROP 'id_member'; check that column/key exists Datei:
« Reply #3 on: March 30, 2024, 11:36:31 am »
Updated the downloads should help your first issue.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16455
    • View Profile
Re: Can't DROP 'id_member'; check that column/key exists Datei:
« Reply #4 on: March 30, 2024, 11:40:51 am »
Regrab the download.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Michel68

  • SMF Gallery Pro Customer
  • Full Member
  • *****
  • Posts: 165
    • View Profile
Re: Can't DROP 'id_member'; check that column/key exists Datei:
« Reply #5 on: March 30, 2024, 11:50:33 am »
This problem always occurs when you want to reinstall an older or the same version. If there is an update with a higher version, then it's not a problem.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16455
    • View Profile
Re: Can't DROP 'id_member'; check that column/key exists Datei:
« Reply #6 on: March 30, 2024, 11:52:31 am »
Yeah old versions will have that error. I am not sure why...Install the latest version of the gallery is always recommended.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Michel68

  • SMF Gallery Pro Customer
  • Full Member
  • *****
  • Posts: 165
    • View Profile
Re: Can't DROP 'id_member'; check that column/key exists Datei:
« Reply #7 on: March 30, 2024, 11:56:46 am »
The main problem is that if you uninstall the current version, you won't be able to reinstall it. The installation script aborts and that's it.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16455
    • View Profile
Re: Can't DROP 'id_member'; check that column/key exists Datei:
« Reply #8 on: March 30, 2024, 11:58:20 am »
Even the latest download? Make sure you delete the old version from the package manager

I removed the code for so that error should not happen anymore.
Code: [Select]
Can't DROP 'id_member'; check that column/key exists
File: /homepages/xx/Packages/temp/galleryinstall2.0.x.php
Line: 1072
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
3480 Views
Last post December 01, 2008, 11:22:54 pm
by Beltazar
1 Replies
5101 Views
Last post November 28, 2009, 03:19:43 pm
by SMFHacks
8 Replies
7435 Views
Last post March 10, 2010, 02:50:38 pm
by expedive
6 Replies
3470 Views
Last post September 11, 2014, 11:16:39 am
by SMFHacks
5 Replies
3333 Views
Last post August 09, 2023, 10:31:48 pm
by tank_fv101

+- Recent Topics

Pretty Urls extras by SMFHacks
May 13, 2024, 10:28:54 am

Mod question by Verrick
May 11, 2024, 02:42:50 pm

i have paid but cant download ad pro. by SMFHacks
May 02, 2024, 11:29:38 pm

Please Help! by SMFHacks
April 17, 2024, 08:04:55 am

Rate own images by fvlog19
April 11, 2024, 10:56:53 am

Tidy Child Boards on 2.1.4 by SMFHacks
April 04, 2024, 03:54:12 pm

Problems SMF 2.0.19 > 2.1.4 SMF Gallery Pro - Recents Images to overall header by Michel68
March 30, 2024, 12:41:08 pm

Can't DROP 'id_member'; check that column/key exists Datei: by SMFHacks
March 30, 2024, 11:58:20 am

No thumbnails on new uploads by Tonyvic
March 29, 2024, 06:26:18 am

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

Powered by EzPortal