[peterlaursen]

Sorry …

SJA would write those file on the client machine form where it is being run …'

I don't understand what is happenng now!

[peterlaursen]

links:

http://www.modwest.com/help/kb1-144.html

http://www.usd.edu/charlie/faqs/server_errors.html

and a general google search:

http://www.google.com/search?client=opera&…=utf-8&oe=utf-8

Can you CHMOD the folders on your webhost with a FTP-client.

SJA needs to write the session.xml and the -log file SOMEWHERE.

It looks like your ISP is messing up permissions!

syntax for SJA:

==========

Command line syntax is

sja jobfile.xml -llog.txt -ssession.xml

The -s and -l parameters for specifying the session file and the log file are optional. A complete file path can be specified. That is useful if you don’t have write privilege to the installation folder. If not specified default values logfile.txt and session.xml are used and file are placed in the directory from where SJA runs

=========================================

Is it a problem with SQLyog GUI or the SJA only ??

[peterlaursen]

I think that both Ritesh and I shal try to remember that 'wired' (= weird ?? – sorry 'bout my English spelling …. ) person 😆

SQLyog 5.1 beta 1 should be out by the end of this week (friday or saturday) if not some unforseen issue occurs. This looks like an issue that should be fixed with next release. Check in by the end of the week, if we should forget you!

[peterlaursen]

OK … since nobody else … I shall attempt to give my 'offering' ..

First: 'FrontPage-like' and PHP is not very much in harmony! Microsoft developed ASP as their Webserver preprocessor language (to compete with PHP and JSP), and I don't think any M$-style GUI tool for web development supports PHP.

Actually I think that with PHP you will basically have to accept to write CODE. You may of course find a design tool with good PHP syntax highligtening and that sort of things. Macromedia Dreamweaver is very good, but expensive. It is also good in the respect that it does not change the CODE itself, when you open a file – as Frontpage does and as Adobe GoLive does.

There are some tools available that can generate PHP code from some kind of template or a database Schema. All I have seen is crap.

With the sort of application that you are thinking of you will also basically need to combine some kind of forms control with a Database enabled scripting language (PHP). That means in practice that your code will be some 'mix' of DHTML (that is basically HTML + CSS + JAVASCRIPT) and PHP. I don't think XFORMS is yet ready to replace DHTML (though it would be preferable), but I may be wrong is this.

Tutorials, resources… That is one advantage with PHP. You will will lots of PHP resources on the internet. The PHP community is very open. A simple google search: http://www.google.com/search?client=opera&…=utf-8&oe=utf-8. Also there are a lot of Forums where people are willing to help .. in all levels.

But it is 'nice work', I think … Get started and then you will be able to ask more specific questions. And there are better places than here for that!

And I have seen some people starting from scratch being able to do wonderful things in a few months!

[peterlaursen]

BTW: the Backup 'powertool' also works OK.

[peterlaursen]

Also the data sync runs (sync'ing DB's 'report-data' and 'test')

Code:

Copyright (c) Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Tue Jan 24 10:08:13 2006

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted
=========================  =======  =======  ========  =======  =======
`t1`                             8        6         4        1  No change  
`t1`                            10        8         2        0  No change  

Total time taken – 1 sec(s)

So you have two options (until the issue is fixed):

1) Use 'copy database to other host' for the first copy

2) Or simply run the first sync against an empty database

[peterlaursen]

Just for those PHP beginners – like me 😀 – I updated the script.

Now there is no more than what there need to be in the printf() function!

Code:

connecting

“;
$connct = mysql_connect(“**host”,”**user”,”**pw”);
echo “

$connct

“;

$myapache = apache_get_version();
echo “

Apache and PHP -versions are:

“;
echo “

$myapache

“;
echo “

 

“;

$database = “**db”;
mysql_select_db($database);
echo “

The database '”;
echo $database;
echo “' is selected

“;

$tabel = “**tbl”;
$showquery = “SELECT count(*) FROM $database.$tabel;”;
echo “

Query goes as: >>>>
“;
echo $showquery;
echo ” >>>>

“;
$result = mysql_query($showquery) or die (mysql_error());
echo “

Query succesfull

“;

$row = mysql_fetch_array($result, MYSQL_NUM);
echo “

Query result :
“;

printf (“%s rows in – – – database: $database – – – table: $tabel “,$row[0]);

mysql_close();
?>

[peterlaursen]

now you said it – so now it is here:

http://www.webyog.com/faq/33_20_en.html

[peterlaursen]

I would then request similar attention to OpenOffice/OpenDocument-format.

But that maybe rather is a question of improved XML-support in SQLyog as a general matter.

[peterlaursen]

I can easily connect with HTTP-tunnelling to Apache 2.0.55/PhP 4.4.2 with HTTP-tunneling. All running on windows (and precompiled binaries). I shall not attempt to compile it on Linux without a RPM script to control the gnuCC compiler on my SuSE Linux ….

Tested with both MySQL 5.0.18 and 4.0.26 .. No problems!

Undoubtedly something happened with that php update at your ISP. Maybe the developers can give a more specific hint when they get back to work! I know from my own experience that good arguments can be important with ISP's !

[peterlaursen]

php 4.4.2 is brand-new. 13th January.

http://www.php.net/

I think I can put it up on my system!

[peterlaursen]

My logfile starts identically

but near the end at 'Connected' it goes different

Code:

Trying to connect
Connected
Enter SetName
DB=latin1n
Client=latin1n
Server=latin1n
Exit SetName
Enter ExecuteSingleQuery
mysql_num_rows in ExecuteSingleQuery
Enter HandleExtraInfo
Exit HandleExtraInfo
Enter convertxmlchars
Input: version()
Output: version()
Exit convertxmlchars
Enter convertxmlchars
Input:
Output:
Exit convertxmlchars
Enter convertxmlchars
Input: 13
Output: 13
Exit convertxmlchars
Enter GetCorrectDataType

And goes on for L-O-N-G …..

hmmm 'Connected' it says .. which two connected? SJA and the tunneller or SJA and Apache …

[peterlaursen]

Let the developers have a look at it!

They start at work in India in about two hours!

With this 'unhappy ending'

Code:

Enter aremodulesinstalled
Enter AreModulesInstalled
Enter processquery
Enter showaccesserror
Exit showaccesserror
Exit AreModulesInstalled

… they must be able to tell to exactly corresponding codeline in the tunnelling file and in sja.exe! Looks to me like Apache does not report correctly about the php_mysql extension (or some other extension) – or SQLyog does not understand it.

There have been a lot of new PHP releases recently. On *nix it is common that you compile them yourself. Maybe your ISP did so – and forgot some compiler flag.

Did you write what was the PHP-version? The script told you!

[peterlaursen]

BTW: the 'copy database to other host' works perfect here with SQLyog 5.02 and MySQL 5.0.18.

You may use that instead. Just right-click a database ….

[peterlaursen]

Confirmed!

Exactly as you desxribe it with MySQL 5.0.18 and SQLyog 5.02

With MySQL 5.0.18 and SQLyog 4.1 it exports perfectly as

Code:

/*
SQLyog Enterprise – MySQL GUI v4.1
Host – 5.0.18-nt-max : Database – report-data
*****************************************
Server version : 5.0.18-nt-max
*/
create database if not exists `report-data`;
USE `report-data`;

/*Table structure for table `t1` */
drop table if exists `t1`;
CREATE TABLE `t1` (
 `id` bigint(20) NOT NULL auto_increment,
 `t` varchar(50) default NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `t1` */
insert into `t1` values (1,'a'),(2,'b'),(3,'c');

hmmm .. they start at work in Bangalore in 2-3 hours. They must be able to tell! I don't know if it could be because it uses the 'Information_Schema' table.

[Author]

Posts