I have managed to convert NopCommerce V1.50 to MySql, including the Database, but am having an issue with the NOP_splitstring_to_table Function called from Nop_ProductLoadAllPaged. I have tracked down where the error is occurring from Nop_ProductLoadAllPaged and it is this line:
SELECT CAST(v_FilteredSpecs AS SIGNED INTEGER) FROM NOP_splitstring_to_table(v_FilteredSpecs,',');
It is thie bit: (v_FilteredSpecs,',') that s causing the error.
Please help !!
Thanks in advance,
Paul.
SELECT CAST(v_FilteredSpecs AS SIGNED INTEGER) FROM NOP_splitstring_to_table(v_FilteredSpecs,',');
It is thie bit: (v_FilteredSpecs,',') that s causing the error.
Please help !!
Thanks in advance,
Paul.
Hi Paul,
This is what I am doing for this issue:
Create a table name temptable, then modify the SP "Nop_splitstring_to_table" to insert the table into this table. Off course dropping all old data before inserting new data into this temptable.
then modify Nop_producloadAllPaged:
CALL NOP_splitstring_to_table(v_FilteredSpecs,',');
INSERT INTO tt_FilteredSpecs(SpecificationAttributeOptionID)
SELECT cast(data as SIGNED INTEGER) FROM NOP_temptable;
I am still modifying the SP script, so I haven't known it is working.
By the way, do you change all the input parameter in SP, by adding "IN" infront of every input parameter? I gota do it else i will get an error like "expect parameter, 2 but got 1".
Nice to share with you.