vba

Hi TCH team, When will newer versions of the various software be made available via Fantastico. eg joomla 2.5.1? Thanks

Will need to investigate whether register globals are turned on in the Unix box - thanks -----------------------

Well, the $_SESSION['new_array'] that we are utilising has the potential to store an array of up to 30 primary elements as well as each element being an array of 6 sub elements ( 2 x floats(4,2), 2 x tinyint(1), 1 x int(11) & 1 x varchar(5)). An aray of arrays. However, it is typically only going to have up to a max of 5 primary elements being updated at any time. By the way, we tried it with all 30 being updated and it worked quite well. To fault find we placed print_r($_SESSION['new_array']) & print_r($new_array) statements everywhere to isolate where the array was being emptied. Basically when we used $new_array = array(), it emptied $_SESSION['new_array']. Just that "1 line of code" stopped us! Our windows dev is slightly behind the unix prod environment - MySQL v5.0.51b (5.0.81), PHP v 5.2.6 (5.2.9). ----------------------------------------

Well problem solved. Ended up being just before the update. I was assigning a session variable(array) to a variable(array). This normally works however there was a small problem which windows lets you get away with and unix does not. //set the new array as type array $new_array = array(); //assign the session array to the new array $new_array = $_SESSION['new_array']; The problem with this is the names, they are both called new_array. Windows recognises them as different and unix does not. Basically the first command to set the new array as type array empties the session array under unix. Once I changed the $new_array to $diff_array it all works fine under unix and windows. So it is all now.

Can we use InnoDB for the schemas and also the engine. I read something about SET storage_engine = InnoDB for a session however cannot find the PHP method of doing so. However I could be barking up the wrong tree on needing the storage engine set to InnoDB to get the writing happening. I can read all I want, just cannot write.

I am still having trouble with being able to write to the dbase. I can read all I like but not write. There does not seem to be one for database connectivity in relationship to Updates. Which is the most appropriate forum to post questions? Thanks

Hi OJB, Yes you are correct "Schema" just using wrong terminology but right item. Well I have still been looking at this and I have added in enough "Try/catch" to make the code twice as long and made sure that I can make them all fail on the Windows system but still no failures on the Production system. I did notice that the default of MyISAM had been set by the MySQL server on all the tables and have change them all to InnoDB. But still without success. The storage engine of the MYSQL server is set to MyISAM, but I cannot change that as it is set by TCH(so hopefully I should not have to and changing the tables should be enough). Any ideas? Thanks vba

Hi, I am using the standard Update command as per below: $conn = db_conn_Write(); $myQuery = "update vb_products set price = '".$pr1."', active = '".$cb1."', specialprice = '".$pr2."', specialactive = '".$cb2."', uom = '".$uom."' where vb_prod_id = '".$vb_prod_id."'"; $result = $conn->query($myQuery); Below here is the connection function for the database: function db_conn_Write() { $result = new mysqli("localhost", "username", "password", "table"); if (mysqli_connect_error()) { $text = 'Could not connect to database server [W-m]'; throw new Exception($text); exit(); } else { return $result; } } This all works fine on my windows development site at home (same versions of PHP and MYSQL), however when I ftp the files to the production environment, all the screens work fine the only failure (no visual error messages) is the actual update to the database. When running the update command as listed in PHPMyAdmin the data updates. Any clues would be much appreciated. Thanks.

I am always amazed at how the simple things give the most trouble. I had in previous attempts changed the port to 21 but had other things wrong. Now I forgot the port Thanks for your help.

Hi, Below is the messages I am getting from Filezilla when attempting to connect to the server. Site and IP changed. Can anyone offer some advice on what might be the problem. I am entering in "site.com, username, password and 2121" as the port. The correct IP resolves however no connection occurs. I am using the main account that is there by default in the ftp accounts page. 20:19:35 Status: Resolving IP-Address for site.com 20:19:35 Trace: ControlSocket.cpp(1057): CRealControlSocket::ContinueConnect(0p1531e38) m_pEngine=0p147e9c8 caller=0p152ebb0 20:19:35 Status: Connecting to 208.??.??.?:2121... 20:19:56 Error: Connection timed out 20:19:56 Trace: CFtpControlSocket::ResetOperation(2114) 20:19:56 Trace: CControlSocket::ResetOperation(2114) 20:19:56 Error: Could not connect to server 20:19:56 Status: Waiting to retry... 20:20:01 Status: Resolving IP-Address for site.com 20:20:01 Trace: ControlSocket.cpp(1057): CRealControlSocket::ContinueConnect(0p150d618) m_pEngine=0p147e9c8 caller=0p152ebb0 20:20:01 Status: Connecting to 208.??.??.?:2121... 20:20:22 Trace: CRealControlSocket::OnClose() 20:20:22 Trace: CFtpControlSocket::ResetOperation(66) 20:20:22 Trace: CControlSocket::ResetOperation(66) 20:20:22 Error: Could not connect to server Thanks for your support.

Hi All, I have worked it out. The validation I was doing on the initial load of the primary page was failing. This then stopped some code from running and thus all my links were not working. The strange thing was that my test server at home (unfortunately windows based) did not exhibit this error as the validation was getting the right information. Due to this being a unix based hosting there is a minor difference in how it handles pages on first load eg the data was different to what windows on first load does. All fixed now. vba

Hi, I uploaded new pages last night into both the public_html and public_html/pages folders. I then happily clicked around and saw that everything was working fine. Now today I have gone to my home page and it is ok however when I try to go to any other pages which are located in "pages" I get 404 error. The home page uses 3 other pages in the "pages" directory to build itself so it can access the files to build but people cannot see the sub pages? If I log into Cpanel and then start FileManager I can then access the pages. Cpanel on its own does not work. Help please. Thanks

Hi Madmanmcp, Thanks for the info, we had noticed that it was coming in around the same time as we do, however not everytime and sometimes when we haven't been there. So thought we would raise it as a question. Looks like it is probably Trends own bots checking to see if our site is a dangerous site. Thanks again for the help. VBA

Yes I do? -- 2008

Hi I am new to Web hosting and new to the TotalChoice Family. I have 2 IP's that are accessing /cpanel that are not mine. I have tried blocking the individual IPs and also the range using IP Deny Manager. The IPs are 150.70.84.28 and 150.70.84.50, they keep appearing in the Latest Visitors list. The IPs are registered to Japan. Can anyone advise on this? Thanks