Nothing showing

Hello Justin,

I see that the page is not being completed because of a fatal error, however the error is not being displayed due to PHP configuration (which is normal for production servers).

I suspect, like the /admin/ folder not containing all files, this is down to one (or more) of the files in the /html/ folder not having been uploaded - that should be all it is.

I would double check that all the sub-directories have been uploaded completely as there may be missing files in others. You can temporarily enable error reporting to see which missing file is causing the error by adding the following code to the end of your config.advanced.php (line before the closing PHP tag at the end)

That should be all it is...

Cheers,
David.
--
PriceTapestry.com

Hi David,

Thanks for that. I think I've got everything functioning now but the error reporting is throwing up the following message:

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in {code saved} on line 45

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in {code saved} on line 50

I wonder if you could tell me how to resolve this?

Thanks in advance

Hi,

Please could you enable database debug mode by changing line 6 of config.advanced.php as follows;

...and then view the page generating the above error again and the actual SQL and MySQL error occurring should be displayed. If you're not sure from the output where the problem lies let me know what is displayed and I'll check it out further with you..

Cheers,
David.
--
PriceTapestry.com

Hi David,

Just to back track a bit, I'm a bit baffled as last night I thought I'd resolved the issues with the lack of functionality. I'd set up a Cron job on the hosting site as recommended in the manual.

I'd read in the forum somewhere that if you were only using one database (as is my case), then it was best to set the table prefix in the config as blank:

$config_databaseTablePrefix = "";

as opposed to how I had it:
$config_databaseTablePrefix = "_pt";

As a result of these changes things seemed to work correctly. The error messages disappeared and I'd managed to register some feeds to test them. Everything seemed to be working fine. The brand, category and merchant buttons were all working and I'd managed to set some feature products on the homepage.

Today the guy I'm working with on this called to say there error messages were back, the feature products have disappeared and when I try to click on the brand, category, merchant buttons I get this message:

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in {code saved} on line 45

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in {code saved} on line 50

Warning: Cannot modify header information - headers already sent by (output started at {code saved}:45) in {code saved} on line 4

So I enabled the debug as you'd suggested. I get the following messages:

On the homepage:
[SELECT * FROM `pt_featured` ORDER BY sequence][Table 'pt_featured' doesn't exist]

When I select one of the top buttons:
[SELECT DISTINCT(brand) as brand FROM `pt_products` ORDER BY brand][Table 'pt_products' doesn't exist]

So I went back into admin home to look at one of the feeds and when I select the Register, indeed some of the fields have reverted back to blank

I'm not sure where to go from here but any help you can give me would be greatly appreciated.

Hello Justin,

I think things have become a bit confused with regards to changing $config_databaseTablePrefix - even for a single site, it is best left as the default e.g.;

(I _think_ that is what you meant you changed it back to rather than "_pt")

Either way, personally at this point, and apologies for the inconvenience as it sounds like you had made good progress setting things up, I think it would be better to re-install the database - you could try first however, just from top level browse to

setup.php?installDB=1

That will create any tables that don't already exist; but you may find it cleaner to delete the database (assuming you created it only for Price Tapestry), re-create it and then re-install with the above default $config_databaseTablePrefix.

Once up and running again, with your first couple of feeds; automation tool jobs etc. you can make a backup from /admin/ using Tools > Backup and Restore - that way if you ever want to start over you can get back to where you were quickly...

If you're not sure of anything I would be happy to look on the site for you - drop me an email if you need any help on the server...

Cheers,
David.
--
PriceTapestry.com