I have the following scripts that works well with a database that was filled using dowalk script but is getting me some errors when using the same scripts on another database filled using gw.
The errors are:
-- BEGIN CUT --
115 Jul 31 12:16:50 [library=../libs/inc.libraries.vts]:23: Field Title\Description\Keywords\Meta\Body non-existent
000 Jul 31 12:16:50 [library=../libs/inc.libraries.vts]:23: SQLExecute() failed with -1 in the function execntexis
100 Jul 31 12:16:50 [library=../libs/inc.libraries.vts]:272: More Values Than Fields in the function Insert
000 Jul 31 12:16:50 [library=../libs/inc.libraries.vts]:272: SQLExecute() failed with -1 in the function execntexis
-- END CUT --
The lines where the error started are:
Line 23:
-- BEGIN CUT --
<$sql_where_string = " WHERE Title\Description\Keywords\Meta\Body LIKEP $$query_search">
-- END CUT --
Line 273:
-- BEGIN CUT --
<sql novars "INSERT INTO querylog VALUES(counter, $REMOTE_HOST, $qinfo, $query)"></sql>
-- END CUT --
I suppose this is because the gw make version 2 compatible databases .. can I use gw with all his line parameters in order to obtain the same database functionality as i obtain when using dowalk script?
I already have a script that get the parameters from a database and run the gw with that specific parameters .. i didn't find enough information about doing the same thing with dowalk.
Thank you
The errors are:
-- BEGIN CUT --
115 Jul 31 12:16:50 [library=../libs/inc.libraries.vts]:23: Field Title\Description\Keywords\Meta\Body non-existent
000 Jul 31 12:16:50 [library=../libs/inc.libraries.vts]:23: SQLExecute() failed with -1 in the function execntexis
100 Jul 31 12:16:50 [library=../libs/inc.libraries.vts]:272: More Values Than Fields in the function Insert
000 Jul 31 12:16:50 [library=../libs/inc.libraries.vts]:272: SQLExecute() failed with -1 in the function execntexis
-- END CUT --
The lines where the error started are:
Line 23:
-- BEGIN CUT --
<$sql_where_string = " WHERE Title\Description\Keywords\Meta\Body LIKEP $$query_search">
-- END CUT --
Line 273:
-- BEGIN CUT --
<sql novars "INSERT INTO querylog VALUES(counter, $REMOTE_HOST, $qinfo, $query)"></sql>
-- END CUT --
I suppose this is because the gw make version 2 compatible databases .. can I use gw with all his line parameters in order to obtain the same database functionality as i obtain when using dowalk script?
I already have a script that get the parameters from a database and run the gw with that specific parameters .. i didn't find enough information about doing the same thing with dowalk.
Thank you