I'm attempting to use PayPal's PHP SDK with their Adaptive Payments API to create a back end script to automate the payment of our website's affiliates. I've set the following constants to the corresponding values I've been given by paypal:
any ideas on this error in Magento 126.96.36.199. I wonder why this happens but Magento 1.4.0 and Magento 188.8.131.52 works fine. The error is caused by accessing Magento Sales Shipment List API with "order_created_at filter. This filter worked in previous versions but with this version it fails. I wonder why this could happen. Also see Magento Issue for reference: [URL] there are some details of request sent to Magento webservice. Here is the actual request:
Here is the response: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'order_created_at' in 'where clause'
When I run the following query, SQLite tells me that there is no such column "test", where "test" is the value in the variable $entryname. I want to store $entryname into the name column, not 'name' into $entryname. Does anyone know how to do this?
my data includes arabic characters which looks like garbage in mysql but displays correctly when run on browser. my questions:
how do i html-encode the output?if i add this to all my files: <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> i get this error: Error: Incorrect string value: 'xE4xEExC3xD8xEFxE6...' for column 'cQuotes' at row 1
Imagine this... I have a field in the database titled 'current_round'. This may only be in the range of 0,1,2,3. Through the application logic, it is impossible to get a number above 3 or less than 0 into the database. Should there be error checking in place to see if the value is malformed (i.e. not in the range 0-3)? Or is this just unnecessary overhead? Is it OK to assume values in a database are correctly formatted/ranged etc (assuming you sanatise/evaluate correctly all user input?)
I am trying unsuccessfully to make an index of several fields from within PHPMyAdmin. (I have done so successfully with several other tables.) Here is the message. _________________________ ALTER TABLE `profiles` ADD INDEX ( `ID` ( 3 ) , `FirstName` ( 30 ) , `LastName` ( 30 ) , `ThumbPhoto` ( 30 ) )
MySQL said: #1089 - Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys _________________________
"Incorrect sub part key" - ? "the used key part isn't a string" - ?
"the used length is longer than the key part" - the numbers match their varchar values. ID is tinytext, which I think means "3" "the storage engine doesn't support unique sub keys" - I'm using InnoDB. Can you give me a clue to what I need to do from here? I'm having this trouble with several tables, but no trouble with other tables. Not sure what the difference is.
I have a script that uses simplexml_load_string() to process a string of xml data that is brought in via curl. The raw xml is ~11Meg and based on what I have read, it can only handle 10Meg.
Forgot the error:
Warning: simplexml_load_string(): Entity: line 6: error: xmlSAX2Characters: huge text node: out of memory in /class.php on line 204
// line 204 $xml = simplexml_load_string($this->getOutput());
I have found this bug report: http://bugs.php.net/49660 but, based on it, it seems that 5.3 was the only version updated(?). We are running 5.1.9. I have tried the fix but get an error that LIBXML_PARSEHUGE is a string and not an integer. There is also no documentation for this constant, that I can find, on php.net.Is there another way of going around this?
I am writing a new gallery and want to read the EXIF data and save it to a database. I have three types of error to deal with that I can think of: 1/ EXIF data not supported - png image. 2/ No EXIF data in the file but EXIF data supported. 3/ This error "Incorrect APP1 Exif Identifier Code" In one case this could be caused by converting a CR2 file to a TIFF file via some HDR software and then saving as a jpg. I think I have delt with 1/ and 2/ but 3/ crashes my code and the data is not saved to the database. The code I am using is below; dealing with error 3/ and any improvements that could be made to my code?
Situation:we plan on using PHP's GnuPG extension to encrypt/decrypt files.Currently we've setup some test cases, using keys generated with GPG.The /Users/username/.gnupg/I am able to get keyinfo for the key I want to use to encrypt/decrypt, but when I attempt to use addencryptkey, I get:(E_WARNING: 2): gnupg::addencryptkey() [gnupg.addencryptkey]: get_key failedI think this is due to the permissions on the ~/.gnupg folder & enclosed files.
The files are owned by me - username, but apache runs as www.A few days ago I did have this working, but it seems each time I use GPG Keychain Access to import / export a key, the folder's permissions are changed.Question:What are the exact permissions required to allow PHP's GnuPG to add encrypt & decrypt keys?
I am working on reviving an old project (that only works with < 5.1) that essentially compiles PHP 5.3 into a PE C++ EXE. I have gotten everthing to work really well on multiple Windows 7 computers with only 2 dlls and 1 exe for most applications! Unfortunately, on XP I get:
the application failed to start because the application configuration is incorrect
I have installed Microsoft Visual C++ 2008 Redistributable Package to no avail. I have also copied msvcm90.dll, msvcr90.dll, msvcp90.dll to the same directory as the exe. This also did not work. Do I just need to compile the project on XP for it to work on XP? I am really good at PHP, but C is not my forte, so I assume I am missing something obvious in the compiler.
EDIT: When I compile with just Multi-threaded (/Mt) I get this:
MSVCRT.lib(MSVCR90.dll) : error LNK2005: _fflush already defined in LIBCMT.lib(fflush.obj) MSVCRT.lib(MSVCR90.dll) : error LNK2005: _malloc already defined in LIBCMT.lib(malloc.obj) MSVCRT.lib(MSVCR90.dll) : error LNK2005: _free already defined in LIBCMT.lib(free.obj) LINK : warning LNK4098: defaultlib 'MSVCRT' conflicts with use of other libs; use /NODEFAULTLIB:library out/console_debug.exe : fatal error LNK1169: one or more multiply defined symbols found
In Table_1, I have imported data from a spreadsheet. In one table column there are mixed values: 94.7, 45.0, 36, car, bus....etc. The datatype is VARCHAR(10) I want to insert the values from this column from Table_1 into a DECIMAL(5,1) field in Table_2. I want the non-numeric values to register as 0.0. This is important. I've tried several things, including CAST(), which works in my MySQL GUI, but gives a long series of warnings. Here is an example of the type of SQL I have tried.
DELETE FROM table_2; INSERT INTO table_2 (NAME, decimal_column) (SELECT NAME , CAST(varchar_column AS DECIMAL(5,1)) FROM table_1) ;
Example of MySQL warnings.
Warning Code : 1366 Incorrect decimal value: '' for column '' at row -1, Warning Code : 1292 Truncated incorrect DECIMAL value: 'house' Also, PHP will have none of it. When I try to run the same query using PHP, I get this fatal error message: Incorrect decimal value: '' for column '' at row -1
So I have this query that's giving me a mysql error: "Column count doesn't match value count at row 1 1136" error. But After having triple checked my connection information and quadruple checking the query I can't see where I'm going wrong. Here's the query in question, a copy of the table will follow:
ive have tried several php scripts for accessing just an access database for now and none of them seem to work. i get it to connect to the database fine but it seems to see nothing in the database even though there is definitely information in the database. here is one of the php scripts ive tried.
i have even tried a SQL version as i have WAMP Server installed and all i get from that one is a blank page when it should show a login confirmation if username/password is correct or an error if username/password are incorrect.
i dont know what i'm doing wrong i'm trying to get all the fields from a specific row by user name i'm using php and i got the connection string down and i made a query like this:
$query = mysql_query("SELECT * FROM <DBname> WHERE name = $_POST[user]");
the variable $_POST[user] was passed to the php code from a previous html form i get the error: Unknown column '<username here>' in 'where clause'
the <username here> part shows whatever i typed in my previous form as a user name
i'm guessing i'm using the wrong syntax and i cant find any help on it perhaps some one could explain this to me and point me to a site or manual on this sort of thing. i treid php.net but they have mostly different functions i couldnt find this one there
However, when the form submits it reports an error of; Warning: mssql_query() [function.mssql-query]: message: Cannot insert the value NULL into column 'created', table 'dbo.users'; column does not allow nulls. INSERT fails.
We have done an echo $q to show the data trying to be inserted and it does show the correct datetime (e.g. 2009-10-28 15:43:00.000), the .000 gets added by the db normally. If I manually create a record in the database, the datetime in the example above is accepted.
when i send it i get this error: Unknown column 'application' in 'field list' i did set data type for the fileType field to varchar. when i remove the fileType all together the record is inserted successfully into database though. ?!! can anyone help please
ERROR 1060 (42S21): Duplicate column name 'audio_sid'
i'm not able to figure out why.the query is below.
Select * from (Select *,case when a.audio_sid is NULL then v.video_sid ELSE a.audio_sid END as SID,case when a.audio_prgm_num is NULL then v.video_prgm_num ELSE a.audio_prgm_num END as PRNO from(Select audio_sid,audio_prgm_num,video_sid,video_prgm_num from audio a left join video v on(audio_sid=video_sid and audio_prgm_num=video_prgm_num) union select audio_sid,audio_prgm_num,video_sid,video_prgm_num from video v left join audio a on (audio_sid=video_sid and audio_prgm_num=video_prgm_num))T left join audio a on (T.audio_sid=a.audio_sid and T.audio_prgm_num = a.audio_prgm_num)left join video v on(T.video_sid=v.video_sid and T.video_prgm_num=v.video_prgm_num))TT left join pcr_info p on(p.pcr_sid=TT.SID and TT.PRNO=p.pcr_prgm_num) right join stream s on (TT.SID=s.stream_id and s.stream_name like 't%');
I'm a vet at mysql 3.0 adn 4.0, and we finally got 5.0 installed on a client's server now, one of my old and reliable sql queries came back at me with this message:
Error #1265 - Data truncated for column 're_volumenumber' at row 1 Apparently 5.0 is more touchy about these things than 4.x. This is fine but is there any way to make it be less touchy so that I can get something up and running? Any setting to change?
BTW, I'm looking at the update query and the actual value in re_volumenumber is blank (i.e. '') -