XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk




1
ccpedigree
Re: animal pedigree database, problems moving to new server

  • 2016/4/26 10:28

  • ccpedigree

  • Just popping in

  • Posts: 9

  • Since: 2016/3/31


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.
Topic | Forum


2
ccpedigree
Re: animal pedigree database, problems moving to new server

  • 2016/4/22 6:58

  • ccpedigree

  • Just popping in

  • Posts: 9

  • Since: 2016/3/31


In the code is this:

le="color: #000000"><?php $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.
Topic | Forum


3
ccpedigree
Re: animal pedigree database, problems moving to new server

  • 2016/4/20 13:10

  • ccpedigree

  • Just popping in

  • Posts: 9

  • Since: 2016/3/31


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.
Topic | Forum


4
ccpedigree
Re: animal pedigree database, problems moving to new server

  • 2016/4/17 14:16

  • ccpedigree

  • Just popping in

  • Posts: 9

  • Since: 2016/3/31


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.
Topic | Forum


5
ccpedigree
Re: animal pedigree database, problems moving to new server

  • 2016/4/14 12:31

  • ccpedigree

  • Just popping in

  • Posts: 9

  • Since: 2016/3/31


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.
Topic | Forum


6
ccpedigree
Re: animal pedigree database, problems moving to new server

  • 2016/4/11 15:05

  • ccpedigree

  • Just popping in

  • Posts: 9

  • Since: 2016/3/31


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?
Topic | Forum


7
ccpedigree
Re: animal pedigree database, problems moving to new server

  • 2016/4/2 13:01

  • ccpedigree

  • Just popping in

  • Posts: 9

  • Since: 2016/3/31


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.
Topic | Forum


8
ccpedigree
Re: animal pedigree database, problems moving to new server

  • 2016/4/1 11:09

  • ccpedigree

  • Just popping in

  • Posts: 9

  • Since: 2016/3/31


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
Topic | Forum


9
ccpedigree
animal pedigree database, problems moving to new server

  • 2016/3/31 14:11

  • ccpedigree

  • Just popping in

  • Posts: 9

  • Since: 2016/3/31


I see this forum has been of great help with other questions regarding the animal pedigree.
I am admin of the website http://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
Topic | Forum



TopTop



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Aug 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!