Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4274
Latest: kellanphil
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43645
Total Topics: 7572
Most Online Today: 58
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 51
Total: 51

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

0 Members and 1 Guest are viewing this topic.

Offline Michel68

  • SMF Gallery Pro Customer
  • Full Member
  • *****
  • Posts: 175
    • 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: 175
    • 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: 16611
    • 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: 16611
    • 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: 16611
    • 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: 175
    • 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: 16611
    • 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: 175
    • 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: 16611
    • 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
3647 Views
Last post December 01, 2008, 11:22:54 pm
by Beltazar
1 Replies
5288 Views
Last post November 28, 2009, 03:19:43 pm
by SMFHacks
8 Replies
7796 Views
Last post March 10, 2010, 02:50:38 pm
by expedive
6 Replies
3670 Views
Last post September 11, 2014, 11:16:39 am
by SMFHacks
6 Replies
4448 Views
Last post July 16, 2024, 10:35:13 pm
by SMFHacks

+- Recent Topics

Ability to exclude categories from ezPortal SMF Gallery random image ezblock by Alistair
January 22, 2025, 08:20:13 am

How to move SMF to new server by SMFHacks
January 21, 2025, 08:45:53 pm

Figuring out settings by SMFHacks
January 12, 2025, 04:56:14 pm

Filesizes incorrect by SMFHacks
January 12, 2025, 02:02:47 pm

December 2024 Sale! by SMFHacks
December 02, 2024, 10:30:38 pm

Denying members some admin settings by rickk
November 17, 2024, 12:02:55 pm

Weird setup by SMFHacks
November 07, 2024, 06:37:41 am

Restoring a deleted photo by Monocero
November 01, 2024, 04:23:56 am

Gallery Pro reinstalation by Lirorobert
October 14, 2024, 01:43:43 am

Move picture from main gallery to user gallery by SMFHacks
October 11, 2024, 09:11:00 pm

Powered by EzPortal