Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 11845
Latest: SamoanOnion
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 42481
Total Topics: 7409
Most Online Today: 33
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 29
Total: 30

Author Topic: Database Error  (Read 11641 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: 16112
    • 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: 16112
    • 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: 16112
    • 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: 16112
    • 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: 16112
    • 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: 16112
    • 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: 16112
    • 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
9897 Views
Last post February 09, 2008, 11:44:03 pm
by ApplianceJunk
10 Replies
9192 Views
Last post February 24, 2009, 08:08:08 pm
by Beltazar
3 Replies
5320 Views
Last post February 25, 2009, 11:52:00 pm
by Sweetwater
7 Replies
5851 Views
Last post June 11, 2009, 09:50:27 pm
by SMFHacks
4 Replies
4693 Views
Last post October 09, 2011, 03:59:37 pm
by SMFHacks

+- Recent Topics

Delete old file by SMFHacks
October 05, 2022, 08:11:13 am

[Feature Request] Thumbnail on topic list by Shades
October 04, 2022, 11:40:26 am

Undefined index: class_ad_seller by SMFHacks
October 04, 2022, 09:33:36 am

"Custom title" badge by Hatshepsut
September 27, 2022, 10:11:27 pm

Category Selection by Anmer
September 18, 2022, 02:40:06 am

Setting a single free download. by Zaphod
September 12, 2022, 10:18:45 pm

Error message "Data too long for column 'ipaddress' at row 1" by SMFHacks
September 12, 2022, 08:49:02 am

SMF to SMF bridge via WP by SMFHacks
September 11, 2022, 09:44:30 am

Video player included by SMFHacks
September 06, 2022, 10:26:27 pm

Upload hangs / doesn't complete by SMFHacks
August 28, 2022, 08:36:21 am

Powered by EzPortal