inserting records into ac_redirects table
Posted: Fri Apr 01, 2011 2:11 pm
Hi all,
I inserted a record directly into the ac_redirects table using
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!
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 (,,,,,,)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!