installed successfully but one table is not exist

Register an Account
Pligg Chat Room
Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 12-24-2006, 02:39 AM
New Pligger
 
Join Date: Dec 2006
Posts: 1
Creating table: 'blogs'...
Creating table: 'categories'...
Creating table: 'comments'...
Creating table: 'friends'...
Creating table: 'languages'...
Creating table: 'links'...
Creating table: 'trackbacks'...
Creating table: 'users'...
Creating table: 'tags'...
Creating table: 'votes'...
Creating table: 'pageviews'....
Creating table: 'config'
Creating table: 'messages'
Creating table: 'modules'
Creating 'god' user...
Inserting default categories...
Inserting default modules...
Inserting default 'config' data...


SQL/DB Error -- [Table 'pligg.pligg_links' doesn't exist]
SQL/DB Error -- [Table 'pligg.pligg_links' doesn't exist]

'links' is in the list,but can't find it in my database. why?

winxp(sp2) + IIS5.1 + PHP5.2 + MySQL5.0.27nt + Pligg9.0beta

Last edited by oodbqpoo; 12-24-2006 at 02:50 AM.
Reply With Quote
  #2 (permalink)  
Old 01-24-2007, 03:43 AM
New Pligger
 
Join Date: Jan 2007
Posts: 1
I changed the row with the query to
PHP Code:
if(!mysql_query$sql$conn )) {echo mysql_errno($conn) . ": " mysql_error($conn) . "\n";} 
just to see why MySQL wouldn't create the table. I got the message:

1101: BLOB/TEXT column 'link_field10' can't have a default value
Reply With Quote
  #3 (permalink)  
Old 03-16-2007, 02:22 PM
New Pligger
 
Join Date: Mar 2007
Posts: 1
remove the " default '' " from the lines in the table_links sql statement inside installtables.php that contain link_field# then re-run install
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Table 'pligg.table_prefixconfig' doesn't exist guarriman Questions and Comments 3 02-19-2010 01:06 AM
Index.php won't open to install nigelnix Questions and Comments 5 02-18-2010 04:59 PM
Warning: Table 'tucknet_newqian_digg.pligg_groups' doesn't exist in seanli Questions and Comments 0 04-23-2009 02:35 AM
Internal Server Error wagthis Questions and Comments 12 01-16-2007 05:20 PM


Pligg Modules and Pligg Templates from Pligg Pro Find support on the Pligg CMS Forum - 24 hours a day! Make a donation to support Pligg CMS development