Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 177
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 178
Total: 178

Author Topic: Database error  (Read 1465 times)

0 Members and 1 Guest are viewing this topic.

Offline Zaphod

  • Downloads Pro Customer
  • Member
  • *****
  • Posts: 36
    • View Profile
    • Three Generals Squad
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: 16436
    • 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
  • Member
  • *****
  • Posts: 36
    • View Profile
    • Three Generals Squad
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: 16436
    • 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
  • Member
  • *****
  • Posts: 36
    • View Profile
    • Three Generals Squad
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: 16436
    • 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
11568 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
4 Replies
6286 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks
3 Replies
3966 Views
Last post December 01, 2013, 05:37:43 pm
by SMFHacks
New database error

Started by Mike66 « 1 2 » Support

23 Replies
8719 Views
Last post February 23, 2015, 12:41:27 pm
by Mike66
0 Replies
2650 Views
Last post June 10, 2015, 03:36:01 am
by elbeer

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

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

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal