New User Errors and confusions

Archived from the Xataface Users forum.

Chris — Wed Jun 22, 2011 10:26 pm

Just keeping track of errors FYI from a new user’s view.

When running installer.php

Code: Select all: Strict Standards: Non-static method Dataface_Installer::mainMenu() should not be called statically in /home/stockchase/public_html/xataface/installer.php on line 546 Xataface

Proceeding find until step 3, downloading tarball
Receive a file which is called yadda.tar.gz
have problems opening it.
File has text at the beginning.

Code: Select all: `

Notice: Undefined variable: compression in /home/stockchase/public_html/xataface/installer.php on line 389

‘Z.0Í2tÔÎÛýSf`

I modified installer to force gz compression and tried again.

Now works with gunzip and tar.

It creates minimal directory which asks for the template_c to be exposed. Which I already did in the initial install directory.

I guess installer.php wasn’t what I was supposed to run.

shannah — Wed Jun 22, 2011 10:34 pm

Looks like there are some issues with the installer and PHP 5.3. You could just turn off “display errors” to get around it for now. I’ll take a look at this for the next release.

You could also just do a manual install. Personally I never use the installer or the makesite script since it’s so easy to just do a manual app setup (4 lines of code and a conf.ini file).

-Steve

Chris — Wed Jun 22, 2011 10:49 pm

Ok after reading a bit more documentation, using makesite.

when creating your releases shouldn’t it be marked as executable (chmod +x makesite)

it works well, but doesn’t create the templates_c directory. I can understand not wanting to set it 777 and making the user do it, (so the user is aware) but it would be nice for the directory to be created.

Going into the just created site, I get a bunch of

Code: Select all: Warning: strftime() [function.strftime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in /home/stockchase/public_html/xataface/lib/Smarty/Smarty_Compiler.class.php on line 400

Which could be eliminated by setting the timezone to something, with a warning that it may need to be modified.
eg date_default_timezone_set(‘America/New_York’);

Chris — Wed Jun 22, 2011 10:51 pm

I know I can get around all these items. I just though you’d like to see a new users perspective. All these things are quick fixes as far as I can see.
Great software BTW.
I’m hoping to use it to revamp http://stockchase.com

Chris — Thu Jun 23, 2011 2:15 am

I’m getting

Code: Select all: Strict Standards: Non-static method Dataface_IO::getByID() should not be called statically in /home/stockchase/stockchase.net/public_html/xataface/dataface-public-api.php on line 247

but I don’t see where it’s coming from. (The code looks fine to me).

shannah — Thu Jun 23, 2011 5:48 pm

This is an issue with PHP 5.3 enforcing strict standards (can’t call nonstatic methods from a static context anymore etc..).

You can work around this by either turning off the display of E_STRICT warnings or simply not displaying errors to the browser.
What version of Xataface are you using. I was pretty sure that the latest had fixed this particular error.

-Steve

Chris — Thu Jun 23, 2011 9:22 pm

I just downloaded it last night so I expect it’s your newest version.
Thing is, I’m developing on my local server with debug stuff turned on, when it’s ready to go it will be on a server that I don’t have control over, so I’d rather avoid things like this if possible.

I think you’ve gotten rid of most of them. I tried xataface about 6 months ago, and this is definitely cleaner.

BTW is it possible to put comments in the ini files.
So I can put stuff in but comment it out, and try out different combinations?

Hmm, found a problem.

Code: Select all: `[Days]
Daily = Daily
Friday = Friday
Monday = Monday
None = None
Saturday = Saturday
Sunday = Sunday
Thursday = Thursday
Tuesday = Tuesday
Wednesday = Wednesday
[sendFreq]
widget:label = “Emails sent”
widget:type = select
vocabulary = Days`

Guess what None evaluates to.
Warning: syntax error, unexpected BOOL_FALSE in /home/stockchase/stockchase.net/public_html/tables/emailTopPicks/fields.ini on line 5 in /home/stockchase/stockchase.net/public_html/xataface/Dataface/ConfigTool.php on line 443
and the parse seems to fail.

I guess I need to change the data in the database to accommodate this?

shannah — Fri Jun 24, 2011 4:11 pm

If your server’s on PHP 5.2 then there won’t be a problem. It’s just 5.3 that gets its panties in a knot for this stuff. The reason these warnings are here is because until recently we were trying to keep PHP 4 compatibility. (You can’t achieve both compatibility and STRICT 5.3 compliance at the same time).

Also, the error that you’re talking about occurs when running the installer correct? You shouldn’t need to do this in the live site.

For the “None” issue there are many workarounds.

e.g.

Store the valuelist in the database.
Define the valuelist as a delegate method (e.g. function valuelist__Days(){}).

-Steve

Chris — Fri Jun 24, 2011 9:24 pm

Actually this error [codeS]trict Standards: Non-static method Dataface_IO::getByID() should not be called statically in /home/stockchase/stockchase.net/public_html/xataface/dataface-public-api.php on line 247[/code]
Is when I’m looking at a table. I’m past the install stage at this point.

shannah — Sat Jun 25, 2011 1:29 pm

This has been fixed in svn for a while now. These warnings should be turned off by default though for any production server.

I don’t really have an eta for releasing the changes in svn. There is much to do to prepare for the next release.

Steve

Chris — Sat Jun 25, 2011 11:10 pm

Is the svn version available for previewing?

I’ve updated my data base to have

Code: Select all: mysql> explain day; +-------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+----------------+ | id | int(10) | NO | PRI | NULL | auto_increment | | name | text | NO | | NULL | | +-------+---------+------+-----+---------+----------------+ 2 rows in set (0.00 sec)

which contains days of the week, None, and Daily as items 1 through 9.

I also have

Code: Select all: explain emailTopPicks; +----------+-------------+------+-----+------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+------------+-------+ | user_id | int(10) | NO | PRI | 0 | | | lastDate | date | YES | | 0000-00-00 | | | sendFreq | varchar(20) | YES | | None | | | day_id | int(10) | YES | | NULL | | +----------+-------------+------+-----+------------+-------+

sendFreq is the same as the day’s Name which corresponds to emailTopPicks.day_id==day.id
I.E.
emailTopPicks.sendFreq == day[emailTopPicks.day_id].Name;

In the emailTopPicks table field I have

Code: Select all: `[Days]
sql = “select id,name from day order by name”
[day_id]
widget:type = select
vocabulary = Days`

which I would expect to show the days in day_id being from the day.Name.
Instead I get

Code: Select all: User id LastDate SendFreq Day id 2 2011-06-21 Daily 1 354 2008-08-11 Daily 1 59 2011-06-21 Daily 1 355 2011-06-21 Daily 1 357 2008-08-11 Daily 1 356 2008-08-11 Daily 1 361 2011-06-18 Saturday 5

Editing a record shows a drop down of Please select, and 1.

What am I doing wrong?

shannah — Sun Jun 26, 2011 12:40 am

[Days]
__sql__ = “select id,name from day order by name”

[day_id]
widget:type = select
vocabulary = Days

Is this snippet from just the fields.ini file or are you showing the contents of your valuelists.ini and fields.ini in one snippet here. The Days valuelist belongs in the valuelists.ini file.

SVN is always publicly accessible. The repository is at http://weblite.ca/svn/dataface/core/trunk

-Steve

Chris — Sun Jun 26, 2011 5:06 am

That was it. Thanks so much.

spoke too soon. That fixed the initial list of records, but when editing a single record I get

Code: Select all: `Strict Standards: Non-static method Dataface_IO::getByID() should not be called statically in /home/stockchase/stockchase.net/public_html/xataface/dataface-public-api.php on line 247
Fatal error: Failed parsing SQL query on select: select id,name from day order by name . The Error was Parse error: Unexpected clause on line 1 select id,name from day order by name ^ found: “day” in /home/stockchase/stockchase.net/public_html/xataface/lib/SQL/Parser.php on line 1752`

The warning should affect anything (just included it here for completeness) but I don’t know where the SQL error is coming from.

I Tried the svn version and the warning is gone but the sql error still persists.

Other tables seem to work ok, so I assume that “day” is giving it problems?

Bug found (svn version)
if using a vocabulary, and the magnifying glass is used to select a filter, the filter still uses the original database id value, instead of the vocabulary values.

shannah — Sun Jun 26, 2011 9:17 am

Since day is also a function name the parser is getting confused. Wrap it in back ticks to clarify.

Steve

Chris — Sun Jun 26, 2011 9:25 pm

That fixed it.
This software is great.

thanks again.

Chris — Sat Jun 25, 2011 11:10 pm

Is the svn version available for previewing?

I’ve updated my data base to have

Code: Select all: mysql> explain day; +-------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+----------------+ | id | int(10) | NO | PRI | NULL | auto_increment | | name | text | NO | | NULL | | +-------+---------+------+-----+---------+----------------+ 2 rows in set (0.00 sec)

which contains days of the week, None, and Daily as items 1 through 9.

I also have

Code: Select all: explain emailTopPicks; +----------+-------------+------+-----+------------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+------------+-------+ | user_id | int(10) | NO | PRI | 0 | | | lastDate | date | YES | | 0000-00-00 | | | sendFreq | varchar(20) | YES | | None | | | day_id | int(10) | YES | | NULL | | +----------+-------------+------+-----+------------+-------+

sendFreq is the same as the day’s Name which corresponds to emailTopPicks.day_id==day.id
I.E.
emailTopPicks.sendFreq == day[emailTopPicks.day_id].Name;

In the emailTopPicks table field I have

Code: Select all: `[Days]
sql = “select id,name from day order by name”
[day_id]
widget:type = select
vocabulary = Days`

which I would expect to show the days in day_id being from the day.Name.
Instead I get

Code: Select all: User id LastDate SendFreq Day id 2 2011-06-21 Daily 1 354 2008-08-11 Daily 1 59 2011-06-21 Daily 1 355 2011-06-21 Daily 1 357 2008-08-11 Daily 1 356 2008-08-11 Daily 1 361 2011-06-18 Saturday 5

Editing a record shows a drop down of Please select, and 1.

What am I doing wrong?

shannah — Sun Jun 26, 2011 12:40 am

[Days]
__sql__ = “select id,name from day order by name”

[day_id]
widget:type = select
vocabulary = Days

Is this snippet from just the fields.ini file or are you showing the contents of your valuelists.ini and fields.ini in one snippet here. The Days valuelist belongs in the valuelists.ini file.

SVN is always publicly accessible. The repository is at http://weblite.ca/svn/dataface/core/trunk

-Steve

Chris — Sun Jun 26, 2011 5:06 am

That was it. Thanks so much.

spoke too soon. That fixed the initial list of records, but when editing a single record I get

Code: Select all: `Strict Standards: Non-static method Dataface_IO::getByID() should not be called statically in /home/stockchase/stockchase.net/public_html/xataface/dataface-public-api.php on line 247
Fatal error: Failed parsing SQL query on select: select id,name from day order by name . The Error was Parse error: Unexpected clause on line 1 select id,name from day order by name ^ found: “day” in /home/stockchase/stockchase.net/public_html/xataface/lib/SQL/Parser.php on line 1752`

The warning should affect anything (just included it here for completeness) but I don’t know where the SQL error is coming from.

I Tried the svn version and the warning is gone but the sql error still persists.

Other tables seem to work ok, so I assume that “day” is giving it problems?

Bug found (svn version)
if using a vocabulary, and the magnifying glass is used to select a filter, the filter still uses the original database id value, instead of the vocabulary values.

shannah — Sun Jun 26, 2011 9:17 am

Since day is also a function name the parser is getting confused. Wrap it in back ticks to clarify.

Steve

Chris — Sun Jun 26, 2011 9:25 pm

That fixed it.
This software is great.

thanks again.

pit — Sun Oct 16, 2011 12:10 am

Hi Steve,

Thanks for the great job first of all!

As there is no separate topic for “Strict standards” issue, i haven’t found anything better than to continue existing one…

There are the same warnings in ‘history logging’:

Strict Standards: Non-static method Dataface_Table::tableExists() should not be called statically, assuming $this from incompatible context in /usr/local/www/apache22/data/xataface/actions/history.php on line 14

Strict Standards: array_walk() expects parameter 2 to be a valid callback, non-static method Text_Diff::trimNewlines() should not be called statically in /usr/local/www/apache22/data/xataface/lib/Text/Diff/Engine/native.php on line 32

shannah — Mon Oct 17, 2011 12:08 pm

What version are you using?

pit — Sat Nov 05, 2011 8:30 am

1.3rc6 build 2510. I’ve solved the issue by switching off PHP messages. Seems to be ok now.
There is another problem now. I’m trying to use table widget (the one stored in XML inside a TEXT field) and getting the following messages (after i create at least one record in the respective table and save it):

Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/www/apache22/data/xataface/lib/XML/Unserializer.php on line 689

Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/www/apache22/data/xataface/lib/XML/Unserializer.php on line 691

Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/www/apache22/data/xataface/lib/XML/Unserializer.php on line 850

Deprecated: Assigning the return value of new by reference is deprecated in /usr/local/www/apache22/data/xataface/lib/XML/Parser.php on line 567

I’ve been trying to remove “&” from these lines, but got the empty pages instead of the table.

shannah — Mon Nov 07, 2011 9:56 am

This had been previously fixed in the SVN trunk (rev 2660). I have merged this fix into the 1.3.x branch so that it will be included with the next 1.3.x release also. (Or you can just work straight of the 1.3.x SVN branch to get the update.

-Steve