SimplePortal

Support => Install and Upgrade => Topic started by: aonavy on January 27, 2011, 09:29:39 AM

Title: Help! Unknown column 'content' in 'field list' File:
Post by: aonavy on January 27, 2011, 09:29:39 AM

im trying to install this portal but im getting this error.

Unknown column 'content' in 'field list'
File: D:\Hosting\7326588\html\Forum\Packages\temp\install2.php
Line: 971

Title: Re: Help! Unknown column 'content' in 'field list' File:
Post by: aonavy on January 27, 2011, 09:31:59 AM

error log from smf:

'new' => 'sp_gallery'
952:    

   

   

   

),
953:    

   

   

);
954:    
955:    

   

   

foreach ($block_updates as $type)
956:    

   

   

   

$smcFunc['db_query']('', '
957:    

   

   

   

   

UPDATE {db_prefix}sp_blocks
958:    

   

   

   

   

SET type = {string:new}
959:    

   

   

   

   

WHERE type = {string:old}',
960:    

   

   

   

   

$type
961:    

   

   

   

);
962:    
963:    

   

   

require_once($sourcedir . '/PortalBlocks.php');
964:    

   

   

$old_parameters = array();
965:    
966:    

   

   

$request = $smcFunc['db_query']('', '
967:    

   

   

   

SELECT id_block, type, content, parameters
968:    

   

   

   

FROM {db_prefix}sp_blocks',
969:    

   

   

   

array(
970:    

   

   

   

)
==>971:    

   

   

);
972:    

   

   

while ($row = $smcFunc['db_fetch_assoc']($request))
973:    

   

   

{
974:    

   

   

   

if (in_array($row['type'], array('sp_bbc', 'sp_html', 'sp_php')))
975:    

   

   

   

{
976:    

   

   

   

   

$old_parameters[] = array(
977:    

   

   

   

   

   

'id_block' => $row['id_block'],
978:    

   

   

   

   

   

'variable' => 'content',
979:    

   

   

   

   

   

'value' => $row['content'],
980:    

   

   

   

   

);
981:    

   

   

   

}
982:    

   

   

   

elseif (function_exists($row['type']))
983:    

   

   

   

{
984:    

   

   

   

   

$type_parameters = $row['type'](array(), 0, true);
985:    
986:    

   

   

   

   

if (empty($row['parameters']) || empty($type_parameters))
987:    

   

   

   

   

   

continue;
988:    
989:    

   

   

   

   

$row['parameters'] = explode(',', $row['parameters']);
990:    
991:    

   

   

   

   

foreach ($type_parameters as $variable => $value

Title: Re: Help! Unknown column 'content' in 'field list' File:
Post by: aonavy on January 27, 2011, 10:50:00 AM

solved .... deleted all sp files in database and reinstalled.

Title: Re: Help! Unknown column 'content' in 'field list' File:
Post by: AngelinaBelle on January 27, 2011, 05:00:14 PM

That's one way to solve the problem. Good job.