Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

About PerlSOL

  • Birthday 12/31/2006

Profile Information

  1. Thank you very much for that :thumbsup: (sorry for the delayed reply) again, many thanks.
  2. Hi again Surfalot... could you help me please when you have some spare time, I have added your latest update to a fresh MS2, all I have done is I emptied the default install using the empty/truncate contrib. I am trying to import a backup from two versions back and am getting this error? 1364 - Field 'manufacturers_url' doesn't have a default value INSERT INTO manufacturers_info( manufacturers_id, languages_id ) VALUES ( 2, '1' ) any idea's please! Thanks
  3. PerlSOL


    may seem a daft question but how would one go about linking to an external page, as it all comes from the database I can't see how I would add a custom page to the menu... I can work out how to do it if i append to the end of the create box but not to be in the middle of the menu? shop link1> shop link2> shop link3> ext link1> (other.php) shop link4> shop link5>
  4. PerlSOL

    New Attribute Manager Released..

    thanks for that... i'll try it shortly as I havn't installed it yet... looking into things before I dive ;)
  5. PerlSOL

    New Attribute Manager Released..

    did anyone get this to work with reg. globals off after?
  6. PerlSOL

    Dynamic SiteMap

    Thanks for pointing this out... how one missed that I don't know! I can stop banging my head on the wall now ;)
  7. PerlSOL

    Protx Direct v2.22

    I am having a problem when I restore the db from a backup... 1067 - Invalid default value for 'txtime' create table protx_direct ( id int(11) unsigned not null auto_increment, customer_id int(11) default '0' not null , order_id int(11) default '0' not null , vendortxcode varchar(40) , txtype varchar(16) , value decimal(15,4) , vpstxid varchar(50) , status varchar(15) , statusdetail varchar(100) , txauthno varchar(10) , securitykey varchar(10) , avscv2 varchar(50) , address_result varchar(20) , postcode_result varchar(20) , CV2_result varchar(20) , 3DSecureStatus varchar(12) , CAVV varchar(32) , txtime timestamp default 'CURRENT_TIMESTAMP' not null , UNIQUE id (id) ) [TEP STOP] I have to then go and rem out the section in the sql file and then I can fix it with phpmysql my searches show there are a few posts about the error 1067 - Invalid default value for 'txtime' but nothing that talks about the restore of a database... can anyone help please as this is driving me nuts. [edited] forgot to say I am using v4.3 [/edited]
  8. I keep getting problems every time I backup or restore i have tried to remove the table an put it back in but it wont let me, its as if there is still some ref: to a table!!! if I google anti_robotreg.frm I get nothing #1005 - Can't create table '.\blabla\anti_robotreg.frm' (errno: 121) I'm using the most recent of everything... SQL PHP... here is the SQL code drop table if exists anti_robotreg; create table anti_robotreg ( session_id char(32) not null , reg_key char(5) not null , timestamp int(11) unsigned default '0' not null , PRIMARY KEY (session_id) ); insert into anti_robotreg (session_id, reg_key, timestamp) values ('e9tdfk5f4a9guhh92us7r5iln2', 'DMNZN', '1183862880'); Has anyone else come across this?
  9. Thanks for getting back to me, I did look at the source to see how one would go about it, and ended up looking for another method, I am now updating these fields via openoffice - mySQL DB link that I just got working :-" ... which is no where near as good as this mod. thanks again for this great contrib.
  10. Hi surfalot, would you know how I can add 'categories_description' and 'categories_heading_title' to this amazing feature? ...when I say amazing I really do meen it, the amount of work this MOD has saved me is beyond words, Many thanks for your hard work, efforts and commitment. :thumbsup:
  11. I have worked out the solution to my problem... (HURRAY!) ... Maximum Content-Length in the server's config.ini Maximum Content-Length = 2-MB Maximum User Content-Length = 10-MB ...and while i'm at it i'll fix that timing out issue you all talked about back about a billion pages ;) php.ini: max_execution_time = 120 ; Maximum execution time of each script, in seconds max_input_time = 120 ; Maximum amount of time each script may spend parsing request data Now I can import a file and all is very happy :) now I can go try it all out, oh and make that dropdown box i knocked up work! :blush: :-" Just to collate some keywords in one post to (help) make this site's search function work can't upload files php5 empty $_POST $_FILES POST problem sambar server config.ini :thumbsup:
  12. Sorry, didn't think you would need the header row...I have followed the code all the way through and found the problem to be with enctype="multipart/form-data"... At first I thought it was all POST data is not working but it just seems to be this multipart/form-data! there are many threads out ther on this subject but no cure found yet :( I have tried the latest PHP being 5.2.3, I have yet to try downgrading not that I want to but if that works!!! eitherway I will post my findings here for all. I'll post the header line if I run into problems once I pass the enctype problem :) thanks again for the replies.
  13. Import EP file from Temp Dir - dropdown box MOD I havn't even got it to work 100% yet and this was annoying me LOL... having to go and see what the filename was called each time and cut n paste the name in the box... so I knocked up the code to populate a drop down box of all the .txt files within the temp folder... if there are no files in there then it shows the original input field. I hope you find it of some use find: <INPUT TYPE="text" name="localfile" size="50"> replace with: <?PHP // <INPUT TYPE="text" name="localfile" size="50"> $the_array = Array(); $handle = opendir($tempdir); while (false!== ($file = readdir($handle))) { if ($file!= "." && $file!= ".." &&!is_dir($file)) { $namearr = split('\.',$file); if ($namearr[count($namearr)-1] == 'txt') $the_array[] = $file; } } closedir($handle); $array_size = count($the_array); if($array_size == 0){ echo (' <INPUT TYPE="text" name="localfile" size="50">' . "\n"); } else { echo (' <select name="localfile" size="1">' . "\n"); foreach ($the_array as $list){ echo (' <option value="' . $list . '">' . $list . '</option>' . "\n"); } echo (' </select>' . "\n"); } ?>
  14. so sorry I forgot to post some example data... it's as given to me from the export: "300","300 Base Unit.gif","300mm Base Unit","<p>300mm Base Unit</p>","","38.7","0.00","","2007-04-07 23:55:19","99","1","Color","2","Size","1","115 x 596","","2","175 x 596","","3","140 x 496","","4","140 x 596","","5","283 x 496","","6","283 x 596","","7","140 x 996","","8","283 x 996","","9","355 x 596","","10","335 x 496","","11","450 x 596","","12","495 x 596","","13","570 x 596","","14","895 x 596","","15","(2) 715 x 296 ICB Door Set","","16","715 x 296","","17","715 x 396","","18","715 x 446","","19","715 x 496","","20","715 x 596","","21","1245 x 296","","22","1245 x 496","","23","1245 x 596","","24","(3) 140 x 496 with (1) 283 x 496","","25","(1) 140 x 596 with (2) 283 x 596","","26","(1) 140 x 996 with (2) 283 x 996","","27","715 x 396 Glazed","","28","715 x 496 Glazed","","29","1200 x 496 Glazed Dresser Door","","30","(1) 715 x 296 with (1) 1245 x 296","","31","(1) 715 x 496 with (1) 1245 x 496","","32","(1) 715 x 596 with (1) 1245 x 596","","33","300 larder door - 715 x 296 & 1245 x 296","","34","500 larder door - 715 x 496 & 1245 x 496","","35","600 larder door - 715 x 596 & 1245 x 596","","36","Worktop (40mm) 1500 x 600","","37","Worktop (40mm) 3000 x 600","","38","Worktop (40mm) 3000 x 640","","39","Worktop (40mm) 3650 x 900","","3","Left/Right","40","L/H","","41","R/H","","4","Slide Type","42","Standard","","43","Blum Tandem ~ Soft Close","","Athens","CONTEMPORARY","ATHENS","BASE UNITS (18mm)","","Taxable Goods","Active",EOREOR
  15. Hi Surfalot thanks for the reply please see below Windows 2k (SAMBAR) oscommerce-2.2ms2-051113 PHP Version 5.2.3 MySQL 5.0.27 $curver = '2.76d-MS2'; I have tried the two links you highlight and had applied these changes (and read ALL these pages) but to no avail, It has been a buggy bumpy ride but one keeps going! ...i've modified the rest of the shop with the register globals patches ok and all is settled and running fine so far, just this fact I can't upload... I can download no problem and followed it going through the GET (IF's) but I cant suss out where it's bailing out... I dont get an error as such just page cannot be displayed, I even tried moving the $split to POST as a hidden form element LOL (digging deep!) I think it's a FILES upload problem but i'm new to php and just stabbing in the dark now! any idea's??? (sit's down scratching one's head)