Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4257
Latest: Alex998.
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 43295
Total Topics: 7523
Most Online Today: 230
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 198
Total: 198

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

0 Members and 2 Guests 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: 16452
    • 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: 16452
    • 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: 16452
    • 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: 16452
    • 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: 16452
    • 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
3432 Views
Last post December 01, 2008, 11:22:54 pm
by Beltazar
1 Replies
4979 Views
Last post November 28, 2009, 03:19:43 pm
by SMFHacks
8 Replies
7325 Views
Last post March 10, 2010, 02:50:38 pm
by expedive
6 Replies
3365 Views
Last post September 11, 2014, 11:16:39 am
by SMFHacks
5 Replies
3191 Views
Last post August 09, 2023, 10:31:48 pm
by tank_fv101

+- Recent Topics

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

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

Powered by EzPortal