Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12414
Latest: mtnclb69
New This Month: 3
New This Week: 0
New Today: 0
Stats
Total Posts: 40848
Total Topics: 7158
Most Online Today: 81
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 36
Total: 36

Author Topic: Database error  (Read 341 times)

0 Members and 1 Guest are viewing this topic.

Offline Zaphod

  • Downloads Pro Customer
  • Newbie
  • *****
  • Posts: 21
    • View Profile
Database error
« on: March 06, 2021, 12:57:48 pm »
Hi, I installed the Downloads pro V5.0.5 after uninstalling the previous free version and updating to smf 2.0.18 from 2.0.17 No problems were encountered during this.

After installing the pro version, I added a file and once it was uploaded and the page refreshed I got the following error below.
--------------------------
Database Error
Unknown column 'money' in 'field list'
File: /home/tgsquad/public_html/smf/Sources/Downloads2.php
Line: 1915

I enclose a part screenshot of the error.
« Last Edit: March 06, 2021, 01:02:38 pm by Zaphod »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15404
    • View Profile
Re: Database error
« Reply #1 on: March 06, 2021, 01:12:56 pm »
It thinks SMFShop is still installed.,
Delete shopVersion from smf_settings database table.



Also, Uncheck this under download settings "Use SMF Shop money as credits instead of download system credits"
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 Zaphod

  • Downloads Pro Customer
  • Newbie
  • *****
  • Posts: 21
    • View Profile
Re: Database error
« Reply #2 on: March 06, 2021, 01:56:49 pm »
Hi thanks for speedy reply, I found and removed the offending line but still get same error message, also the line "Use shop money was unchecked.

I never used to look after the downloads, but after speaking to the former operator they had tried the "Shop" but uninstalled it and used to rem out the lines in the downloads2.php when ever he installed a newer version (prior to now I never knew this) of the free download system.

Apart from searching the database, would it be easier to install the shop, then uninstall and have the mod remove the database data? Just a thought.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15404
    • View Profile
Re: Database error
« Reply #3 on: March 06, 2021, 02:10:42 pm »
It does require editing the smf_settings table and removing the row.

The uninstall for SMF Shop does not delete entries added via the smf_settings table.
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 Zaphod

  • Downloads Pro Customer
  • Newbie
  • *****
  • Posts: 21
    • View Profile
Re: Database error
« Reply #4 on: March 06, 2021, 03:01:01 pm »
Hi again, I wrote a query and found many entries of the string in question all gone and so far so good. I did notice a message when uploading a file in the add download page but never took notice of it as i needed to see if my I love SMF database was good. All was well and no error on downloads2.php.

many thanks for the pointer, never knew what devious methods the previous op got up too.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15404
    • View Profile
Re: Database error
« Reply #5 on: March 06, 2021, 03:26:42 pm »
Glad you have it working!
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
4 Replies
8531 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
10 Replies
8864 Views
Last post February 24, 2009, 08:08:08 pm
by Beltazar
Database Error

Started by pioneer « 1 2 » Support

22 Replies
11177 Views
Last post April 18, 2009, 11:58:55 am
by SMFHacks
5 Replies
5079 Views
Last post January 22, 2010, 11:26:48 am
by SMFHacks
4 Replies
4013 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks

+- Recent Topics

From SMF Gallery Lite to SMF Gallery Pro by SMFHacks
Today at 12:30:14 pm

looking for SMF mods by cloudsurph
April 13, 2021, 11:59:07 am

siapamoyanganda.com/familyforum/ by SMFHacks
April 12, 2021, 07:55:58 am

Problem with SimpleAudioVideoEmbedder by Panoulis64
April 08, 2021, 09:08:58 am

An error occurred! You must select a photo. by SMFHacks
April 01, 2021, 11:49:48 am

embed video in forum theme by SMFHacks
April 01, 2021, 11:49:15 am

Just bought Awesome Post Ratings by replayuk
March 28, 2021, 03:38:52 am

Errors when creating a category & terms by SMFHacks
March 24, 2021, 08:23:38 pm

Wanted trade option by SMFHacks
March 23, 2021, 05:07:15 pm

Arcade system dead or re-incarnation. by SMFHacks
March 19, 2021, 09:32:57 am

Powered by EzPortal