fGallery Issues? WP-Forum Issues?

February 7th, 2007 by lvlolvlo in htc dream

Well some of you who have new blogs using Wordpress 2.1+ might have run into a small little problem when trying to use Fredrik’s cool plug-ins. So here’s something you can do if you get that stupid error

*dbname*.wp_fim_cat’ doesn’t exist

fGallery Fix

WPForum Fix

Just download the one you need and run the SQL query from in phpmyadmin.

To give you some background on what’s going on here’s my take on it… basically the tables needed to store the data for the plug-ins isn’t being created. So to make it work, simply create the table manually.

That’s all hope you can enjoy using his plug-ins like how I have been!

*UPDATE*

Some people have had some other issues with their install after applying the needed SQL queries, so here’s some instructions on how to fix it.

Option 1

  1. Create a second install of wordpress on a sub-domain
  2. Make sure to install worpdress 2.0 NOT 2.1
  3. Once WP2.0 is installed proceed to install WP Froums
  4. Once WP Forums is installed copy over the directory to your existing WP-Forums install.

Option 2

  1. Create a second install of wordpress on a sub-domain
  2. Make sure to install wordpress 2.0 NOT 2.1
  3. Migrate your existing site (file uploads, themes, plug-ins (exclusive of WPForum files), and SQL tables (exclusive of WPForum tables) ONLY)
  4. Install WP-Forums
  5. Then run the WP 2.1 Upgrade
  6. Re-migrate your entire site this time inclusive of the WP files

Though Option 2 is a bit more lengthy I prefer it…

***UPDATE 2****

Thanks to Tomsn who has come up with a simple fix to this. Now it’s not completley ready; however, it will get rid of the nasty errors.
How to fix you ask? Well again two options:

Option 1 (use this if you have not installed WP-Forums)

  1. Download WPForum Fix
  2. Download Patched WP Forum 1.74
  3. Install Patch WP Forum 1.74
  4. Run the WP Forum Fix SQL Query from phpmyadmin

Option 2 (use this if you have installed WP-Forums already)

  1. Download  WP Forum SQL Patch
  2. Download WP Forum Patched File
  3. Unzip the forum-function.php, and replace the existing forum-function.php with this one.

Now there is remains one issue still that will hopefully be fixed soon which is after applying this patch on some databases if a user posts a posts it’ll automatically become a sticky. I myself have not looked into this so I don’t even know where to begin. If you do experience this, please voice them in the forum.


19 Responses to “fGallery Issues? WP-Forum Issues?”

  1. wala
    February 10th, 2007 at 9:51 pm



    still an there’s an error.. :cry:

  2. lvlolvlo
    February 11th, 2007 at 1:21 am



    two things….can’t help much if you don’t state the error. second, post your errors over at the author’s forum as you will get the most amount of help there. http://www.fahlstad.se/

  3. Jef Jones
    February 14th, 2007 at 12:42 am



    Thanks for this! You’ve made my week.

  4. Søren
    February 21st, 2007 at 3:17 am



    I still get an error when trying to create a gallery:

    Unknown column ‘parent’ in ‘field list’

    After copy/pasting your otherwise nice patch :)

  5. lvlolvlo
    February 21st, 2007 at 7:29 pm



    Søren,

    There are some new instructions I have added, I didn’t have the time before.

  6. gumdrop
    March 6th, 2007 at 9:34 am



    Trying to activate another plugin when this one is activated it seems to want to re-install/activate again. Consequently giving MySQL dup errors. However, I am using the mu-wordpress. Any ideas?:?:

  7. lvlolvlo
    March 6th, 2007 at 1:56 pm



    Please post your issues at the author’s website. http://www.fahlstad.se/

    Thank you.

  8. ryan
    March 15th, 2007 at 7:14 am



    “You have to choose at least one column to display”

    I keep getting this when I run the query’s…I’m not versed in DB stuff, but I’ve run a query before, I know i’m missing something obvious…what is it?

    thanks

  9. Alphawolf
    March 18th, 2007 at 9:24 am



    Hey all,

    if someone has problems with posting date issues, here’s my 1.7.4 fix for the forum-functions.php file. When I posted a new post or thread, posting date returned something like 30.11.1998, which obviously was wrong.

    I also improved german translation and special chars support a bit.

    So, here’s my german forum-functions.php fix:
    http://www.schloebe.de/wordpress/wp-forum-fix/forum-functions.phps

    And my working SQL dump:
    http://www.schloebe.de/wordpress/wp-forum-fix/db_wp-forum_174.sql

    Hope that this might help some of you.

    Cheers

  10. ofi
    March 21st, 2007 at 2:26 am



    Hi
    I just run this fGallery Fix and got this error in sql

    SQL query:

    CREATE TABLE IF NOT EXISTS `wp_fim_cat` (
    `catname` varchar( 255 ) NOT NULL default ”,
    `id` int( 11 ) NOT NULL AUTO_INCREMENT ,
    `date` datetime default NULL ,
    `description` text NOT NULL ,
    `folder` varchar( 255 ) NOT NULL default ”,
    `cover` varchar( 50 ) default ”,
    `status` varchar( 20 ) NOT NULL default ‘public’,
    `password` varchar( 50 ) NOT NULL default ”,
    PRIMARY KEY ( `id` )
    ) TYPE = MYISAM AUTO_INCREMENT =1;

    MySQL said: Documentation
    #3 – Error writing file ‘./koddncom_wordpress/wp_fim_cat.frm’ (Errcode: 28)

  11. ofi
    March 23rd, 2007 at 12:00 am



    np, got it

  12. Dailyfunnypics
    March 25th, 2007 at 11:00 am



    It took my too much time to solve this problem :D . Dude why your link is not on http://www.fahlstad.se/wp-plugins/fgallery/ ? Am sure, There will be many people who suffered from same problem, but don’t have a time to search your valuable page. ;) But still now its work for mine http://dailyfunnypics.com and happy. LOL

  13. Gnoletcom
    April 13th, 2007 at 1:09 pm



    Please join for discussions on topics about The Virtual Reality.
    Technology development of The Virtual Reality and its perspectives.
    Gnolet.com

  14. Stefano
    April 24th, 2007 at 7:41 am



    Thank you for your fGallery Fix, I was getting crazy with this :smile:

  15. Pratt
    April 26th, 2007 at 1:01 pm



    Im getting a “select status from wp_fim_cat WHERE id =” error after doing the sql queries you suggested :(

  16. zzmcthddid
    June 14th, 2007 at 7:56 am



    Hello! Good Site! Thanks you! xunpxechab

  17. mbangert
    July 11th, 2007 at 12:38 pm



    so does anyone know how to get rid of the sticky problem? I have managed to fix the sql issue but now all my posts are straight away marked as “sticky”…
    some help/advice would be very useful :)

    cheers

  18. Hien
    December 14th, 2007 at 7:11 am



    I might have solved the problem: check this..

    Open up fgallery-plugin.php in the fgallery folder, use notepad, or some ascii authoring tools!, not wordpad!

    Remember, deactivate the plugin first!

    Now let’s do some editing to the file.

    find this line ~ around line 296

    // create new table

    somewhere below.. you’ll see this line:

    get_currentuserinfo();

    Okay, basically this is to prevent any other than admin to install the gallery, and I obviously didn’t bother to fix this function, so I just cancel them out with “//” to prevent them from being processed.

    So…

    // get_currentuserinfo();
    // if ($user_level < 8)
    // {
    // return;
    // }
    // else
    // {

    create tables command…

    // }

    Ok, now, proceed to activate that plugin. See how it works?

  19. eric
    February 2nd, 2008 at 5:34 pm



    Hi,
    I tried to use Wp-Forum with with Wp Site 2.3.2 but I can’t ceate a forum… I tried to install 1.7.4 patch (after delete sql table & re create with patch) and I have the same problem.
    When I look my forum profile, plugin tell me “no subscription” ??? What does it mean ? What can be the reason to not work fine.
    Thanks a lot for your help…

Leave a Reply

  • Register

    • XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

    • Categories

    • Photos