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: 43293
Total Topics: 7522
Most Online Today: 118
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 100
Total: 100

Author Topic: Database Error  (Read 13074 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: 16451
    • 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: 16451
    • 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: 16451
    • 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: 16451
    • 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: 16451
    • 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: 16451
    • 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: 16451
    • 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
11603 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
10 Replies
10515 Views
Last post February 24, 2009, 08:08:08 pm
by Beltazar
3 Replies
6513 Views
Last post February 25, 2009, 11:52:00 pm
by Sweetwater
7 Replies
7461 Views
Last post June 11, 2009, 09:50:27 pm
by SMFHacks
4 Replies
6338 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks

+- Recent Topics

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

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

Powered by EzPortal