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: 201
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 268
Total: 268

Author Topic: Database Error  (Read 13026 times)

0 Members and 1 Guest are viewing this topic.

Offline pioneer

  • Jr. Member
  • **
  • Posts: 91
    • View Profile
    • www.birdboards.com
Database Error
« on: April 11, 2009, 03:28:59 am »
I have placed bidding on my classifieds and i am getting this error.  Would anyone have a idea how to solve this out.

Unknown table 'Il' in field list
File: /var/www/html/Sources/classifieds2.php
Line: 5170

Many Thanks.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Database Error
« Reply #1 on: April 11, 2009, 08:37:00 am »
Fixed for
Quote
1.2.21
!Fixed database error SMF 2.0 on buy it now.
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 pioneer

  • Jr. Member
  • **
  • Posts: 91
    • View Profile
    • www.birdboards.com
Re: Database Error
« Reply #2 on: April 12, 2009, 09:57:07 pm »
Hi can you tell me is it time for me to Pay for renew of classifieds on 1.2.21

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Database Error
« Reply #3 on: April 12, 2009, 10:25:50 pm »
You are still in the group so you are still active.
Check under
http://www.smfhacks.com/index.php?action=license
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 pioneer

  • Jr. Member
  • **
  • Posts: 91
    • View Profile
    • www.birdboards.com
Re: Database Error
« Reply #4 on: April 12, 2009, 10:43:11 pm »
I will try solve all problems by installing a new database in spare time.

Then copy all posts, members and so on to it.

Many Thanks

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Database Error
« Reply #5 on: April 12, 2009, 10:52:11 pm »
Please grab the latest update of the Classifieds should fix that database error.
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 pioneer

  • Jr. Member
  • **
  • Posts: 91
    • View Profile
    • www.birdboards.com
Re: Database Error
« Reply #6 on: April 13, 2009, 01:26:06 am »
The latest fix worked fine as far as i can see.  But i still get this error.  Can you tell me how i fix Paypal account!

Database Error
Unknown column 'l.D_LISTING' in 'field list'
File: /var/www/html/Sources/classifieds2.php
Line: 5169

Many Thanks

Offline pioneer

  • Jr. Member
  • **
  • Posts: 91
    • View Profile
    • www.birdboards.com
Re: Database Error
« Reply #7 on: April 13, 2009, 05:01:59 pm »
I have just notice whatever ad i try to delete it does not let me and i get this message.


Database Error

Table 'db7351_smf_ads.ID_MEMBER' doesn't exist
File: /var/www/html/Sources/classifieds2.php
Line: 1355

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Database Error
« Reply #8 on: April 13, 2009, 07:31:55 pm »
Fixed both errors one of them my fault should have fixed it the last update mistyped

1.2.21.1
!Fixed database error SMF 2.0 deleting listing
!Fixed database error SMF 2.0 on buy it now.


For paypal you can also experiment with test transactions using the sandbox mode.
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 pioneer

  • Jr. Member
  • **
  • Posts: 91
    • View Profile
    • www.birdboards.com
Re: Database Error
« Reply #9 on: April 14, 2009, 08:39:26 am »
I have just done a fresh install of both the Gallery then Classifieds and i am still getting the error message to delete some ads for a new fresh install of a Database for SMF 2.0 RC1

If i try to delete within the control panel i see this message.  And it will tell me the same as i posted for a different database username problem!

An Error Has Occurred!
This package cannot be uninstalled, because there is no uninstaller!

Please contact the mod author for more information.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Database Error
« Reply #10 on: April 14, 2009, 08:44:58 pm »
If you are deleting an upgrade package you can just delete the package.
If you are upgrading there is no need to uninstall the old version. Just grab the upgrade package and install it.
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 pioneer

  • Jr. Member
  • **
  • Posts: 91
    • View Profile
    • www.birdboards.com
Re: Database Error
« Reply #11 on: April 14, 2009, 09:04:25 pm »
This is a new fresh database i have installed along with download from http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc1_install.zip i have your ads & gallery placed in this.  This is the message i get as i try to delete a test ads.

Table 'db7351_pioneer077.ID_MEMBER' doesn't exist
File: /var/www/html/ads/Sources/classifieds2.php
Line: 1355

The Admin > Packages > Both Uninstall shows now

Many Thanks

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Database Error
« Reply #12 on: April 14, 2009, 10:54:41 pm »
Can you attach your Classifieds2.php file
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 pioneer

  • Jr. Member
  • **
  • Posts: 91
    • View Profile
    • www.birdboards.com
Re: Database Error
« Reply #13 on: April 14, 2009, 11:02:05 pm »
Thank you,

For your kind help.


Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Database Error
« Reply #14 on: April 15, 2009, 07:45:40 am »
Wrong file should be sources/classifieds2.php
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
10 Replies
10481 Views
Last post February 24, 2009, 08:08:08 pm
by Beltazar
3 Replies
6489 Views
Last post February 25, 2009, 11:52:00 pm
by Sweetwater
7 Replies
7440 Views
Last post June 11, 2009, 09:50:27 pm
by SMFHacks
4 Replies
6287 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks

+- 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