All Good Things Must Come To An End

As you all know, I have been doing WordPress plugins and supporting it for the past 6 years. These 6 years of my life, I have been through my polytechnic education, my national service as well as my university education.

I just graduated from university in December 2009 and have been looking for full-time jobs. I am offered a full-time job and will be starting work on 1st February 2010.

I regret to say that I am NOT ABLE to provide support for my plugins anymore due to my full-time job commitment. I will leave this forum open and let the community help one another.

However, I WILL still update my plugins whenever I can and you still can report bugs to me via email and I will try to fix it.


« previous next »
Pages: [1]   Go Down

Author Topic: Error at activation  (Read 7076 times)

0 Members and 1 Guest are viewing this topic.

Offline sfong15

  • Newbie
  • *
  • Posts: 6
    • View Profile
Error at activation
« on: 18 July 2007, 09:13 »
I'm using version 1.0 and running WP2.2, got this error

WordPress database error: [Unknown column 'file_name' in 'order clause']
SELECT * FROM wp_downloads ORDER BY file_name ASC

when activation is clicked?
Logged

Offline Ttech

  • Official Support
  • Global Moderator
  • *****
  • Posts: 4,294
    • View Profile
Re: Error at activation
« Reply #1 on: 18 July 2007, 14:30 »
Ah what version of PHP and MySQL, your site, etc?
Logged
Learning and Helping one day at a time.



DevNode.org Operator - The IRC network for Programers

Offline GaMerZ

  • lesterchan.net
  • Administrator
  • *****
  • Posts: 11,536
    • View Profile
  • WordPress Version: WordPress 2.9.x
  • Theme Name: lesterchan.net v3.4
Re: Error at activation
« Reply #2 on: 18 July 2007, 16:20 »
it seems that your table structure is not created properly.

Drop that table and run this code in phpmyadmin:
Code: [Select]
CREATE TABLE `wp_downloads` (
  `file_id` int(10) NOT NULL auto_increment,
  `file` tinytext,
  `file_name` text NOT NULL,
  `file_des` text NOT NULL,
  `file_size` varchar(20) NOT NULL,
  `file_category` int(2) NOT NULL default '0',
  `file_date` varchar(20) NOT NULL default '',
  `file_hits` int(10) NOT NULL default '0',
  `file_permission` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`file_id`)
)
Logged

++ lesterchan.net - Lester Chan's Website

I regret to say that I am not able to provide support for my plugins anymore due to my full-time job commitment. I will leave this forum open and let the community help one another.

Offline Ttech

  • Official Support
  • Global Moderator
  • *****
  • Posts: 4,294
    • View Profile
Re: Error at activation
« Reply #3 on: 18 July 2007, 19:17 »
We need to create a file that has the latest DB query to create the tables for users that have a problem with the auto creation.
Logged
Learning and Helping one day at a time.



DevNode.org Operator - The IRC network for Programers

Offline sfong15

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Error at activation
« Reply #4 on: 19 July 2007, 06:08 »
Quote from: Ttech on 18 July 2007, 14:30
Ah what version of PHP and MySQL, your site, etc?


I was just trying it under XAMPP 1.6.2, i.e. Apache 2.2.4 (win32) and PHP 5.2.2.

May be I'll drop that incomplete table as suggested and start over again.
Logged

Offline GaMerZ

  • lesterchan.net
  • Administrator
  • *****
  • Posts: 11,536
    • View Profile
  • WordPress Version: WordPress 2.9.x
  • Theme Name: lesterchan.net v3.4
Re: Error at activation
« Reply #5 on: 19 July 2007, 06:40 »
sure thing, let us know again
Logged

++ lesterchan.net - Lester Chan's Website

I regret to say that I am not able to provide support for my plugins anymore due to my full-time job commitment. I will leave this forum open and let the community help one another.

Offline sfong15

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Error at activation
« Reply #6 on: 19 July 2007, 07:05 »
Quote from: GaMerZ on 19 July 2007, 06:40
sure thing, let us know again


It's working now at localhost so next step would be using this at hosting but I'll have to completely rewrite my download page here template.sfong.net/?page_id=32  :(

I looked at the table structure that caused the error, it has id, label, date, file, downloads, file_permission only.   Hope this helps.

thanks again for a great plugin
Logged

Offline GaMerZ

  • lesterchan.net
  • Administrator
  • *****
  • Posts: 11,536
    • View Profile
  • WordPress Version: WordPress 2.9.x
  • Theme Name: lesterchan.net v3.4
Re: Error at activation
« Reply #7 on: 19 July 2007, 08:18 »
Eh you sure you got the right plugin at first? LOL? because I do not have label.
Logged

++ lesterchan.net - Lester Chan's Website

I regret to say that I am not able to provide support for my plugins anymore due to my full-time job commitment. I will leave this forum open and let the community help one another.

Offline Ttech

  • Official Support
  • Global Moderator
  • *****
  • Posts: 4,294
    • View Profile
Re: Error at activation
« Reply #8 on: 19 July 2007, 15:39 »
could explain afew things. Why it wouldn't work. :D
Logged
Learning and Helping one day at a time.



DevNode.org Operator - The IRC network for Programers

Offline sfong15

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Error at activation
« Reply #9 on: 21 July 2007, 06:25 »
Quote from: GaMerZ on 19 July 2007, 08:18
Eh you sure you got the right plugin at first? LOL? because I do not have label.


You don't mind showing me link to download the latest copy, do you?
Logged

Offline GaMerZ

  • lesterchan.net
  • Administrator
  • *****
  • Posts: 11,536
    • View Profile
  • WordPress Version: WordPress 2.9.x
  • Theme Name: lesterchan.net v3.4
Re: Error at activation
« Reply #10 on: 21 July 2007, 12:10 »
Logged

++ lesterchan.net - Lester Chan's Website

I regret to say that I am not able to provide support for my plugins anymore due to my full-time job commitment. I will leave this forum open and let the community help one another.

Offline Ttech

  • Official Support
  • Global Moderator
  • *****
  • Posts: 4,294
    • View Profile
Re: Error at activation
« Reply #11 on: 21 July 2007, 20:08 »
:)
Logged
Learning and Helping one day at a time.



DevNode.org Operator - The IRC network for Programers

Offline Ttech

  • Official Support
  • Global Moderator
  • *****
  • Posts: 4,294
    • View Profile
Re: Error at activation
« Reply #12 on: 21 July 2007, 20:08 »
Isn't it on the forum view?
Logged
Learning and Helping one day at a time.



DevNode.org Operator - The IRC network for Programers
Pages: [1]   Go Up
« previous next »