xoops forums

Forum Index


Board index » All Posts (ccpedigree)




ccpedigree

Just popping in
Posted on: 2016/4/26 10:28
ccpedigree
ccpedigree (Show more)
Just popping in
Posts: 9
Since: 2016/3/31
#1

Re: animal pedigree database, problems moving to new server

Thanks, changed the queries on our version (1.30) and works ok now.

Not ready for testing the latest module yet, since this is a production site with more than 52000 dogs entered.


ccpedigree

Just popping in
Posted on: 2016/4/22 6:58
ccpedigree
ccpedigree (Show more)
Just popping in
Posts: 9
Since: 2016/3/31
#2

Re: animal pedigree database, problems moving to new server

In the code is this:

$query "INSERT INTO ".$xoopsDB->prefix("mod_pedigree_temp")." VALUES ('".$random."','".unhtmlentities($name)."','".$id_eigenaar."','".$id_fokker."','".$user."','".$roft."','','','".$foto."', ''".$usersql.")";
        
//echo $query; die();
$xoopsDB->query($query);


So how can I prevent SQL Injection errors from Protector when I insert a field with a quote in the value?

unhtmlentities, mysql_real_escape_string, addslashes, all triggered Protector.


ccpedigree

Just popping in
Posted on: 2016/4/20 13:10
ccpedigree
ccpedigree (Show more)
Just popping in
Posts: 9
Since: 2016/3/31
#3

Re: animal pedigree database, problems moving to new server

2 problems occur with version 1.30:

- When adding a dog with an ' in the name (e.g. Test's Dog) an SQL injection is found. I already tried mysql_real_escape_string and mysqli_real_escape_string with the same result

- Default value for a date field is set to string "YYYY/MM/DD", yet when you add a dog, the date of today is filled in the field, so not the default value as configured in the module.

Any help would be appreciated.


ccpedigree

Just popping in
Posted on: 2016/4/17 14:16
ccpedigree
ccpedigree (Show more)
Just popping in
Posts: 9
Since: 2016/3/31
#4

Re: animal pedigree database, problems moving to new server

Quote:

supergran wrote:
As a suggestion:
In terms of usability there seems only an alphabetical list to search fro the sire and dam for a mating rather than the search box to start inputting the name as it used to be. When there are thousands of dogs in a database that isn't very practical.


I currently have over 50,000 dogs in it and that is also the reason that I really want to stick to this program and not change to any other online database. Indeed searching only on the first letter of the name for a parent can make it difficult. But if you check the url bar, you can see that first letter is also there and there you can add the rest of the name, making it much easier to find the correct dog. I have for example also over 300 dogs with the name Asia (without kennelname or nothing) and for those I use Ctrl+F and let the browser search for the correct pedigreenumber (mostly I use just a part of the number) and like that hardly loose any time locating the correct dog.


ccpedigree

Just popping in
Posted on: 2016/4/14 12:31
ccpedigree
ccpedigree (Show more)
Just popping in
Posts: 9
Since: 2016/3/31
#5

Re: animal pedigree database, problems moving to new server

Alpha 6 gives blank pages.

1.30 Beta1 with Xoops 2.5.7 works ok.

I now am converting the data from the old pedigree site into the new site, manually with PHPMyAdmin.

Thanks for your help.


ccpedigree

Just popping in
Posted on: 2016/4/11 15:05
ccpedigree
ccpedigree (Show more)
Just popping in
Posts: 9
Since: 2016/3/31
#6

Re: animal pedigree database, problems moving to new server

I installed a blank Xoops 2.5.7.2, that works.

When I install the Animal module, the site keeps working, except the Animal module returns a blank page. No errors in debug, etc.

I also tested this on a local Wamp install, same issue. Also nothing in php_error.log, just a blank page.

So it must be the Animal module....but without any errors thrown it is hard to find where....any ideas?


ccpedigree

Just popping in
Posted on: 2016/4/2 13:01
ccpedigree
ccpedigree (Show more)
Just popping in
Posts: 9
Since: 2016/3/31
#7

Re: animal pedigree database, problems moving to new server

On the old server we're using:
5.3.3-7

On the new server:
5.3.29

The error logs are currently not showing any errors.


ccpedigree

Just popping in
Posted on: 2016/4/1 11:09
ccpedigree
ccpedigree (Show more)
Just popping in
Posts: 9
Since: 2016/3/31
#8

Re: animal pedigree database, problems moving to new server

Hi Mamba,

PHP version is 5.3.29.

If I set debug in database still no errors appear, just a blank page.

I also disabled each module in the database, no difference.

Changed theme to default in database, no difference.

Put error reporting E_ALL in code, no difference.

If I change the database login in mainfile.php, an error is thrown. So mainfile.php is processed.

I think the PHP versions are different on the servers.

Xoops version is 2.3.3b


ccpedigree

Just popping in
Posted on: 2016/3/31 14:11
ccpedigree
ccpedigree (Show more)
Just popping in
Posts: 9
Since: 2016/3/31
#9

animal pedigree database, problems moving to new server

I see this forum has been of great help with other questions regarding the animal pedigree.
I am admin of the website www.canecorsopedigree.com and we are trying to move the site to a new server. We keep running into problems to get the site active on the new server. There is always and http/500 error and we don't know where it's coming from. Can you help us please??
We run pedigree module version 1.28 and system admin version 2.13



TopTop