muscapaul's PHP-Fusion website

Posted by in-jet on 20-10-2006 22:29

Hi - I am trying to infuse Terms beta 20061006.

In the Admin panel I get a Table doesn't exist error: Table 'hydraeucom_87648_db1.fusion_term_settings' doesn't existTable 'hydraeucom_87648_db1.fusion_term_settings' doesn't exist

I can see two tables in my database: fusion_terms and fusion_term_cat but no settings.

It seems that the locale $type variable is then undefined and things goes wild.

I first infused the default configuration and had no errors until the Admin panel. I then renamed Glossary_infusion.php and infused the Glossary version with the same result.

I followed the Readme instructions, but I did not use any of the changed-files in the zip.

Where did I go wrong?

Jesper

Posted by muscapaul on 21-10-2006 00:03

I just checked on localhost with the files from the download and there it works perfectly.

1. Which version are you trying: Dictionary, Glossary or standard? ;)
2. Have you tried defusing the infusion and re-infusing it? Or extracting the zip archive again and replacing the files?
3. What versions PHP and MySQl has your server?

Notice: Undefined index: post_edituser in /home/muscapal/public_html/print.php on line 114
Edited by muscapaul on 21-10-2006 00:16

Posted by in-jet on 23-10-2006 14:21

Hi again
1. I tried both standard and Glossary with the same result. I first infused standard, got the error, defused and checked that all tables had been removed, renamed the Glossary_infusion.php as per instructions and infused again. Same result.
2. I have not tried to replace the files. I did that now. I replace all files in the infusion_terms, not just the infusion.php. Same result. I only get the two first tables created.
3. I should be running php 5.0.4. It's a hosted web site.

Hope this helps you locate the problem. Again, I have done nothing but uploading the files as described in Readme. Did I overlook some other changes I needed to do?

Jesper

Jesper

Notice: Undefined index: post_edituser in /home/muscapal/public_html/print.php on line 114
Edited by in-jet on 23-10-2006 14:22

Posted by muscapaul on 03-11-2006 15:30

Can you paste this code in a new custom page, give it a provisional title and hit preview?
If there is any error message (either after you hit preview or when trying to use the infusion), please report it here.
Make certain you put in the right locale term for $locale['term204'] below and, if necessary, translate $locale['term605'].

Code

<?php

$result = dbquery("CREATE TABLE ".$db_prefix."term_settings (

  term_org varchar(100) NOT NULL default '',

  term_to varchar(100) NOT NULL default '',

  term_ratings tinyint(1) NOT NULL default '',

  term_usergroup tinyint(3) NOT NULL default '',

  term_type tinyint(1) NOT NULL default ''

) TYPE=MyISAM;");

if (!$result) $fail = "error one";

echo $fail;



$locale['term204'] = "one"; //replace 'one' for 'Term' (Glossary), 'Word' (Dictionary), 'Term/Word' (Default) or the translation into your language

$locale['term605'] = "Please, set Target Language in Dictionary - General Settings]"; //or replace for the translation into your language

$result = dbquery("INSERT INTO ".$db_prefix."term_settings (term_org, term_to, term_ratings, term_usergroup, term_type) VALUES ('".$locale['term204']."', '".$locale['term605']."', '0', '103', '2')");

   if (!$result) $fails = "error two";

echo $fails;

?>

Notice: Undefined index: post_edituser in /home/muscapal/public_html/print.php on line 114
Edited by muscapaul on 03-11-2006 15:30

Posted by in-jet on 05-11-2006 04:05

Sorry Paul. I thought I posted this a couple of days ago, but it is gone.

The error seems to be related to the field term_ratings.

Invalid default value for 'term_ratings'error oneTable 'hydraeucom_87648_db1.fusion_term_settings' doesn't existerror two

I hope this helps identify the problem.

Jesper

Posted by muscapaul on 13-11-2006 13:31

Another try, Please report any error messages here again.

Code

<?php

$result = dbquery("CREATE TABLE ".$db_prefix."term_settings (

  term_org varchar(100) NOT NULL default '',

  term_to varchar(100) NOT NULL default '',

  term_ratings tinyint(1) NOT NULL default '0',

  term_usergroup tinyint(3) NOT NULL default '0',

  term_type tinyint(1) NOT NULL default '0'

) TYPE=MyISAM;");

if (!$result) $fail = "error one";

echo $fail;



$locale['term204'] = "one"; //replace 'one' for 'Term' (Glossary), 'Word' (Dictionary), 'Term/Word' (Default) or the translation into your language

$locale['term605'] = "Please, set Target Language in Dictionary - General Settings]"; //or replace for the translation into your language

$result = dbquery("INSERT INTO ".$db_prefix."term_settings (term_org, term_to, term_ratings, term_usergroup, term_type) VALUES ('".$locale['term204']."', '".$locale['term605']."', '0', '103', '2')");

   if (!$result) $fails = "error two";

echo $fails;

?>