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: 43295
Total Topics: 7523
Most Online Today: 230
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 218
Total: 218

Author Topic: Error after manual install  (Read 5341 times)

0 Members and 1 Guest are viewing this topic.

Offline djdubuque

  • Member
  • *
  • Posts: 3
    • View Profile
Error after manual install
« on: January 04, 2008, 09:52:24 am »
Unknown column 'ID_CAT' in 'field list'
File: /home/xxxx/public_html/smf/Sources/Load.php(1726) : eval()'d code
Line: 159

Code for that is;
"-------->starts here>
$request = db_query("
         SELECT variable, value
         FROM {$db_prefix}settings", false, false);
      $modSettings = array();
      if (!$request)
         db_fatal_error();
      while ($row = mysql_fetch_row($request))
         $modSettings[$row[0]] = $row[1];
      mysql_free_result($request);      <----ends here>

I had to add the TABLE xxx_gallery_cat .  After adding the TABLE now I get the above error.  Should I add a colum in the TABLE as xxxID_CAT?

Offline djdubuque

  • Member
  • *
  • Posts: 3
    • View Profile
Re: Error after manual install
« Reply #1 on: January 04, 2008, 11:57:30 am »
I think I corrected the error, now most of gallery works.  The part that doesn't work is "add category" I add a category but then it errors our with''
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND approved = 1' at line 1
File: /home/xxxxxx/public_HTML/smf/Sources/Load.php(1726) : eval()'d code
Line: 1216
"

Any ideas out there?  I can empty the table gallery_cat and it will allow me to try and add a category.  But same thing each time.

Offline djdubuque

  • Member
  • *
  • Posts: 3
    • View Profile
Re: Error after manual install
« Reply #2 on: January 05, 2008, 11:29:16 am »
Looks like I fixed the problems, I had to build the dB manually. 

"galleryinstall.php you will need to run the queires inside the file manually on your database if you do a manual install."
« Last Edit: January 05, 2008, 11:39:09 am by djdubuque »

 

Related Topics

  Subject / Started by Replies Last post
5 Replies
4425 Views
Last post November 30, 2007, 02:06:47 pm
by vixen220
7 Replies
7572 Views
Last post February 25, 2008, 02:01:23 am
by biokonsult
1 Replies
6401 Views
Last post February 21, 2009, 09:30:33 pm
by MalteseFalconX
1 Replies
2803 Views
Last post August 15, 2019, 08:17:45 am
by SMFHacks
3 Replies
907 Views
Last post August 08, 2021, 07:23:49 pm
by SMFHacks

+- Recent Topics

Please Help! by SMFHacks
April 17, 2024, 08:04:55 am

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

Powered by EzPortal