inserting records into ac_redirects table

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
azar
Ensign (ENS)
Ensign (ENS)
Posts: 15
Joined: Sat Nov 27, 2010 11:43 am

inserting records into ac_redirects table

Post by azar » Fri Apr 01, 2011 2:11 pm

Hi all,

I inserted a record directly into the ac_redirects table using

Code: Select all

insert into ac_redirects(storeid,sourceurl,loweredsourceurl,targeturl,useregex,createddate,orderby) values (,,,,,,)
the query works fine and inserts a record in the table. when i view the resulting redirect from admin/SEO/fixed redirects, it seems to be identical to the redirects that i have created manually. however it does not actually work.

i run SQL profiler and see that AC is doing the same insert statement when i create and save the redirect manually. the only difference is that AC is also updating ac_users to set the last active date, etc.. which cannot possibly interfere with how redirects work, or can it?

anyone knows solution to the above or any other way of easily creating 1000 redirects without manually doing one by one?

Thanks!

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: inserting records into ac_redirects table

Post by mazhar » Thu Apr 14, 2011 6:51 am

Have a look at this thread viewtopic.php?f=42&t=15143

Post Reply