Problem with xataface-2.0.3 application under linux mint 18

[rec...@icking-music-archive.org]

I've updated my linux mint OS from release 17.3 to release 18. Mysql and phpmyadmin works, but unfortunately not my xataface-2.0.3 application.

All I see when I access the application with my browser is

display();

index.php contains

<?php //Main Application access point
require_once "/var/www/html/xataface-2.0.3/public-api.php";
df_init(__FILE__, "http://localhost/xataface-2.0.3")->display();

To me it looks like function df_init doesn't work anymore as intended.

Are there any log files I can look at?

Any obvious installation steps I'm missing?

My attempts to install from scratch fail as well. Nothing happens when I access a fresh  xataface-2.0.3.

Greetings

[Christian Mondrup]

 In /var/log/apache2/error.log there's an error message from my installation attempt:

[Sun Jul 03 09:53:04.578880 2016] [:error] [pid 25272] [client 127.0.0.1:59204] PHP Fatal error:  Uncaught Error: Call to undefined function mysql_connect() in /share/xataface-2.1.2/xf/db/drivers/mysql.php:2\nStack trace:\n#0 /share/xataface-2.1.2/installer.php(525): xf_db_connect('localhost', 'xxxx', 'xxxx')\n#1 /share/xataface-2.1.2/installer.php(540): db()\n#2 {main}\n  thrown in /share/xataface-2.1.2/xf/db/drivers/mysql.php on line 2

Through google searches I realized that func mysql_connect(), part of php5-mysql, has been deprecated for a while. This module must have been present in Mint 17.3, but is not part of the Mint 18 distribution. I guess the problems with my xataface application are related to incompatibilities between xataface and newer Ubuntu/Mint distributions. Also the most recent xataface 2.1.2 references mysql_connect()

Greetings

[Christian Mondrup]

Den søndag den 3. juli 2016 kl. 16.15.23 UTC+2 skrev Christian Mondrup:

Den søndag den 3. juli 2016 kl. 13.40.35 UTC+2 skrev Christian Mondrup:

I've updated my linux mint OS from release 17.3 to release 18. Mysql and phpmyadmin works, but unfortunately not my xataface-2.0.3 application.

All I see when I access the application with my browser is

display();

The same happens when I create a new xataface 2.1.2 application using the 'makesite' script. Before I got that far I needed to patch installer.php, line 32:

if ( !defined('XF_DB_DRIVER') ){
//    define('XF_DB_DRIVER','mysql');
    define('XF_DB_DRIVER','mysqli');
}

[Steve Hannah]

You don't need to change any source.

http://xataface-tips.blogspot.ca/2014/06/using-mysqli-in-xataface.html

Steve

--
You received this message because you are subscribed to the Google Groups "Xataface" group.
Visit this group at https://groups.google.com/group/xataface.
To view this discussion on the web visit https://groups.google.com/d/msgid/xataface/e4576f10-fdc4-4ec6-8422-4648e71c62d0%40googlegroups.com.

--

Steve Hannah

Web Lite Solutions Corp.

[Christian Mondrup]

On Sunday, 3 July 2016 19:18:01 UTC+2, Steve Hannah wrote:

You don't need to change any source.

http://xataface-tips.blogspot.ca/2014/06/using-mysqli-in-xataface.html

That's true for running an existing application but not for the initial step for creating an application. Besides I still can't get the created application to work, as outlined in previous postings.
 

Steve

[Steve Hannah]

"as outlined in previous postings".

The error you posted said it couldn't find mysql_connect.  So you're using the mysql driver.  Either install the mysql lib, or follow the instructions on the link I sent for using mysqli.

http://xataface-tips.blogspot.ca/2014/06/using-mysqli-in-xataface.html

If the auto installer won't work for you, just skip to a manual install.  

http://xataface.com/wiki/How_to_build_a_PHP_MySQL_Application_with_4_lines_of_code

Steve

--

You received this message because you are subscribed to the Google Groups "Xataface" group.
Visit this group at https://groups.google.com/group/xataface.

To view this discussion on the web visit https://groups.google.com/d/msgid/xataface/77764142-5790-489a-87ee-90a35f93a42f%40googlegroups.com.

[Christian Mondrup]

On Sunday, 3 July 2016 19:31:00 UTC+2, Steve Hannah wrote:

"as outlined in previous postings".

The error you posted said it couldn't find mysql_connect.  So you're using the mysql driver.  Either install the mysql lib, or follow the instructions on the link I sent for using mysqli.

http://xataface-tips.blogspot.ca/2014/06/using-mysqli-in-xataface.html

If the auto installer won't work for you, just skip to a manual install.  

http://xataface.com/wiki/How_to_build_a_PHP_MySQL_Application_with_4_lines_of_code

- I create a new application using makesite. The result is the attach tarball.

- I unpack the tarball and make the directory available on localhost web space

- I click the URL and get a message telling me to create a directory: template_c writeable for apache

- I do so and click the URL once again. The result is what you see in the attached screenshot of a part of the window

This screen is not quite what I expect from the xataface online instruction on creating a new application. Did I miss something?

[Steve Hannah]

The 2nd parameter of your df_init() call inside index.php is incorrect.  It must point to your xataface directory (a URL - relative or absolute).

Steve

To view this discussion on the web visit https://groups.google.com/d/msgid/xataface/d836ebff-dbb5-417f-8765-7e7757a784b5%40googlegroups.com.

[Christian Mondrup]

On Monday, 11 July 2016 17:28:19 UTC+2, Steve Hannah wrote:

The 2nd parameter of your df_init() call inside index.php is incorrect.  It must point to your xataface directory (a URL - relative or absolute).

blush - I should have checked that.

I've got my application up and running incl. an alternative logo image upon several google searches. Unfortunately my google searches didn't help me to to enable the ckeditor module as a replacement of fckeditor which I was using under xataface 2.0.3.

I've followed the instructions given at http://xataface.com/dox/modules/ckeditor/latest/:

- I've downloaded xataface-module-ckeditor-master.zip, unpacked it and copied the directory 'xataface-module-ckeditor-master' to the modules subdirectory of my application, renamed to 'ckeditor'

- I've added a section to my con.ini
  [_modules]
      modules_ckeditor=modules/ckeditor/ckeditor.php

- I've configured fields.ini for the field, for which I need the editor:
  [Excerpt]
      widget:type=ckeditor

But the editor does not load when I access the field. /var/log/appache2/ says

[Tue Jul 12 22:54:27.222985 2016] [:error] [pid 3346] [client 127.0.0.1:40110] PHP Warning:  require_once(/share/Gerson/modules/ckeditor/ckeditor.php): failed to open stream: No such file or directory in /share/xataface-2.1.2/config.inc.php on line 252, referer: http://localhost/Gerson/index.php?-table=Literature_Excerpt
[Tue Jul 12 22:54:27.223056 2016] [:error] [pid 3346] [client 127.0.0.1:40110] PHP Fatal error:  require_once(): Failed opening required '/share/Gerson/modules/ckeditor/ckeditor.php' (include_path='.:/share/xataface-2.1.2:/share/xataface-2.1.2/lib:/usr/share/php') in /share/xataface-2.1.2/config.inc.php on line 252, referer: http://localhost/Gerson/index.php?-table=Literature_Excerpt

I do have the file '/share/Gerson/modules/ckeditor/ckeditor.php'

[Christian Mondrup]

On Tuesday, 12 July 2016 23:37:58 UTC+2, Christian Mondrup wrote:

On Monday, 11 July 2016 17:28:19 UTC+2, Steve Hannah wrote:

The 2nd parameter of your df_init() call inside index.php is incorrect.  It must point to your xataface directory (a URL - relative or absolute).

blush - I should have checked that.

I've got my application up and running incl. an alternative logo image upon several google searches. Unfortunately my google searches didn't help me to to enable the ckeditor module as a replacement of fckeditor which I was using under xataface 2.0.3.

I've followed the instructions given at http://xataface.com/dox/modules/ckeditor/latest/:

- I've downloaded xataface-module-ckeditor-master.zip, unpacked it and copied the directory 'xataface-module-ckeditor-master' to the modules subdirectory of my application, renamed to 'ckeditor'

- I've added a section to my con.ini
  [_modules]
      modules_ckeditor=modules/ckeditor/ckeditor.php

- I've configured fields.ini for the field, for which I need the editor:
  [Excerpt]
      widget:type=ckeditor

But the editor does not load when I access the field. /var/log/appache2/ says

[Tue Jul 12 22:54:27.222985 2016] [:error] [pid 3346] [client 127.0.0.1:40110] PHP Warning:  require_once(/share/Gerson/modules/ckeditor/ckeditor.php): failed to open stream: No such file or directory in /share/xataface-2.1.2/config.inc.php on line 252, referer: http://localhost/Gerson/index.php?-table=Literature_Excerpt
[Tue Jul 12 22:54:27.223056 2016] [:error] [pid 3346] [client 127.0.0.1:40110] PHP Fatal error:  require_once(): Failed opening required '/share/Gerson/modules/ckeditor/ckeditor.php' (include_path='.:/share/xataface-2.1.2:/share/xataface-2.1.2/lib:/usr/share/php') in /share/xataface-2.1.2/config.inc.php on line 252, referer: http://localhost/Gerson/index.php?-table=Literature_Excerpt

I do have the file '/share/Gerson/modules/ckeditor/ckeditor.php'

I wonder whether there's a problem with modules/ckeditor/widget.php. Near the end of function &buildWidget there's a statement

$jt->import('xataface/modules/ckeditor/ckeditor-widget.js');

As far as I reckon there's no file with the relative path 'xataface/modules/ckeditor/ckeditor-widget.js'. But within in my application I do have a file 'modules/ckeditor/js/ckeditor-widget.js' It doesn't help, however, to modify the statement to something like


$jt->import('modules/ckeditor/js/ckeditor-widget.js');

or

$jt->import('Gerson/modules/ckeditor/js/ckeditor-widget.js');

where 'Gerson' is the root folder of my application

[Christian Mondrup]

On Wednesday, 13 July 2016 00:33:40 UTC+2, Christian Mondrup wrote:

On Tuesday, 12 July 2016 23:37:58 UTC+2, Christian Mondrup wrote:

On Monday, 11 July 2016 17:28:19 UTC+2, Steve Hannah wrote:

The 2nd parameter of your df_init() call inside index.php is incorrect.  It must point to your xataface directory (a URL - relative or absolute).

blush - I should have checked that.

I've got my application up and running incl. an alternative logo image upon several google searches. Unfortunately my google searches didn't help me to to enable the ckeditor module as a replacement of fckeditor which I was using under xataface 2.0.3.

I've followed the instructions given at http://xataface.com/dox/modules/ckeditor/latest/:

- I've downloaded xataface-module-ckeditor-master.zip, unpacked it and copied the directory 'xataface-module-ckeditor-master' to the modules subdirectory of my application, renamed to 'ckeditor'

- I've added a section to my con.ini
  [_modules]
      modules_ckeditor=modules/ckeditor/ckeditor.php

- I've configured fields.ini for the field, for which I need the editor:
  [Excerpt]
      widget:type=ckeditor

But the editor does not load when I access the field. /var/log/appache2/ says

[Tue Jul 12 22:54:27.222985 2016] [:error] [pid 3346] [client 127.0.0.1:40110] PHP Warning:  require_once(/share/Gerson/modules/ckeditor/ckeditor.php): failed to open stream: No such file or directory in /share/xataface-2.1.2/config.inc.php on line 252, referer: http://localhost/Gerson/index.php?-table=Literature_Excerpt
[Tue Jul 12 22:54:27.223056 2016] [:error] [pid 3346] [client 127.0.0.1:40110] PHP Fatal error:  require_once(): Failed opening required '/share/Gerson/modules/ckeditor/ckeditor.php' (include_path='.:/share/xataface-2.1.2:/share/xataface-2.1.2/lib:/usr/share/php') in /share/xataface-2.1.2/config.inc.php on line 252, referer: http://localhost/Gerson/index.php?-table=Literature_Excerpt

The error message above occurs only when the ckeditor module is located within the xataface root folder as modules/ckeditor. I did that as an experiment caused by this line in http://xataface.com/dox/modules/ckeditor/latest/

'Copying the ckeditor directory into your application's (or xataface's) modules directory. '

With the ckeditor module located as modules/ckeditor within my application root folder I get no errors in /var/log/apache2 when I access the field requiring ckeditor. I just don't get any widget.

[Christian Mondrup]

I'm too embarrassed to explain how I got ckeditor working!