Fermé

Database import Primary key duplicate issue

ok so, i need to change the frequency of the email user, currently its empty - as i have so many emails, i want to update these within SQL otherwise it will take a long time, - I’ve previous thought about updating these for the import method within PHPLIST but this hasn’t worked.

within the database there are two main tables:

phplist_user_user

&

phplist_user_user_attribute

in order for the RSS frequency to be updated to daily for each email address, an entry must be made into this last table, - the RSS frequency attribute id is 39 & 40 = the userid ( is the customer id which relates to their email address) and the Value needs to be set to 1 for the attribute id 39 & 40, please see the image [url removed, login to view]

if i manually update these details within SEQUEL PRO for this table, then it works, but I’m not able to import a .cv directly due to a Primary Key issue, i need this table (file will be given upon awarding the project) importing and i think it should then work ok, alternatively - if your able to select all user id in table phplist_user_user and create a record for then in phplist_user_user_attribute with attribute 39 and a value of 1 and repeat this for attribute 40 then that should also work ok.

Compétences : MySQL, PHP, SQL

Voir plus : duplicate entry key primary

Concernant l'employeur :
( 53 commentaires ) bangkok, Thailand

N° du projet : #8473922

19 freelances ont fait une offre moyenne de 19 $ /heure pour ce travail

meet2amitvw

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself developer so you will directly work with me. No mediators. No managers. No subcontractors. see my recent Plus

20 $ USD / heure
(121 Commentaires)
8.7
madhavdutta

Hi Dear, Hope you are doing well !! I have gone through your project description. I can understand that you are looking for importing Primary key duplicate issue therefore I am looking forward to discuss and mo Plus

22 $ USD / heure
(144 Commentaires)
8.5
fattahaabdul

I will import it. i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level. Why you should hire me- 1. I have a very good co Plus

26 $ USD / heure
(29 Commentaires)
7.4
r4rony

We have designed and developed many Custom PHP websites. Please check:- CUSTOM PHP WEBSITES ( Mobile compatible design ) ===================== http://offtomeet.com http://citruscheckinns.in/ http://wdp.simpl Plus

15 $ USD / heure
(47 Commentaires)
6.7
phamtech211

Dear Sir/ Madam, My name is Henry - the owner of PHAMTECH Co. My team is really interested in this project as it is exactly within our scope of expertise: We are web/ app design & development company located in Plus

15 $ USD / heure
(16 Commentaires)
6.6
developerhunk

Hello sir,, i have read the project description and requirements carefully and i am confident that i am able to do it..I have checked the Dropbox link .. please talk to me once then we will discuss about the project, Plus

15 $ USD / heure
(41 Commentaires)
6.7
VnBestSolutions

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Plus

21 $ USD / heure
(85 Commentaires)
6.3
audelk

hi sir, im expert in php. i have read your problem. i can do this project without a glitch.. thank you odel

16 $ USD / heure
(25 Commentaires)
5.6
haovo

hi, I can build a small application which allow you load data from csv file to UI then you maybe take some changes if you want to and click on import button. the program will auto detect duplicated primary key and c Plus

20 $ USD / heure
(21 Commentaires)
4.9
acronymsolutions

Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am Personally working on : RDBMS : MS Access,Oracle,MySQL, MSSQL Server 7.0/2000/2008R2 and Onwards. Database Tools : Database Config Plus

22 $ USD / heure
(36 Commentaires)
5.5
speedev196

Hi dear. My name is JiaoMing. I am an expert in web develop such as PHP, AngularJS, Restful API, HTML, CSS, Jquery. I already checked your job. Your job is very interest. I would be happy to accept your requirement Plus

21 $ USD / heure
(12 Commentaires)
4.5
vinaysinghh

I am sql expert certified by Oracle corporation and having more then 5 yrs of experience in sql Oracle and mysql as database administrator

17 $ USD / heure
(7 Commentaires)
3.9
pynetvn

A proposal has not yet been provided

21 $ USD / heure
(12 Commentaires)
3.4
kirvish23

Hi Dear, I am having 7+ yrs of exp in PHP/MYSQL. I can help you in data import from CSV and help you sort out your issue

15 $ USD / heure
(1 Commentaire)
1.6
dongjin1010

Dear sir. thanks for your job posting. I saw your description very carefully. As I am excellent web developer, I understood your issues . Please show me your php source code. I will fix asap. I am ready now. T Plus

22 $ USD / heure
(0 Commentaires)
0.0
infynic

Hello sir, Greeting of the day!! We have carefully read your job description and We have more than 4+ years of working experience in of your required skills. And I am strongest at all of your required qualities. Plus

22 $ USD / heure
(0 Commentaires)
0.0
uqbar

I can use a loop function to go through the records in the first table and create one record of each user_id in the second one.

22 $ USD / heure
(0 Commentaires)
0.0
tryvinod

Hi, I am in Sydney and working for one of the biggest banks in Australia. I have many years of Database Development experience and I am quite good at writing SQL statements and solving database issues. I like to Plus

22 $ USD / heure
(0 Commentaires)
0.0
eko0809

Proposal belum diberikan

15 $ USD / heure
(0 Commentaires)
0.0
rewati086

I am bidding it to build my history. I will make sure that this is done within planned time. Please share the details to move forward.

16 $ USD / heure
(0 Commentaires)
0.0