Comments (2)
diegoabadan
commented on September 13, 2024
Hi @juanCure!
Could you check if there is more than one controlled_vocab_entry_id = 100 in the source OJS?
One hypothesis is that this duplication exists at the origin, in which case it would be necessary to remove it beforehand and export the content again.
from fulljournaltransfer.
juanCure
commented on September 13, 2024
Hi @diegoabadan thanks for your response, I have 783 rows in the controlled_vocab_entries table of the source instance:
controlled_vocab_entry_id | controlled_vocab_id | seq
---------------------------+---------------------+-----
1 | 1 | 0
2 | 1 | 1
3 | 1 | 2
4 | 1 | 3
5 | 2 | 0
6 | 2 | 0
7 | 2 | 0
8 | 2 | 0
9 | 2 | 0
10 | 2 | 0
11 | 2 | 0
97 | 4 | 0
98 | 4 | 0
99 | 4 | 0
100 | 4 | 0
101 | 4 | 0
102 | 4 | 0
103 | 4 | 0
104 | 4 | 0
...
777 | 4 | 0
778 | 4 | 0
779 | 4 | 0
780 | 4 | 0
781 | 4 | 0
782 | 4 | 0
783 | 4 | 0
(783 filas)
while in the controlled_vocab_entries table of the destination instance I have:
controlled_vocab_entry_id | controlled_vocab_id | seq
---------------------------+---------------------+-----
100 | 100 | 1
101 | 100 | 2
102 | 100 | 3
110 | 101 | 1
111 | 101 | 2
112 | 101 | 3
113 | 101 | 4
114 | 101 | 5
115 | 101 | 6
116 | 101 | 7
120 | 102 | 1
121 | 102 | 2
122 | 102 | 3
130 | 103 | 1
131 | 103 | 2
132 | 103 | 3
133 | 103 | 4
134 | 103 | 5
135 | 103 | 6
136 | 103 | 7
137 | 103 | 8
138 | 103 | 9
139 | 103 | 10
140 | 103 | 11
141 | 103 | 12
150 | 104 | 1
151 | 104 | 2
200 | 200 | 1
201 | 200 | 2
202 | 200 | 3
203 | 200 | 4
300 | 300 | 1
301 | 300 | 2
302 | 300 | 3
303 | 300 | 4
304 | 300 | 5
305 | 300 | 6
306 | 300 | 7
310 | 301 | 1
311 | 301 | 2
312 | 301 | 3
313 | 301 | 4
314 | 301 | 5
315 | 301 | 6
316 | 301 | 7
(45 filas)
I thought to change the definition of the primary key on this table, to consider the other 2 columns in this table; however I wasn't sure about it. By the other hand, if I remove the rows in the source instance, I suppose I have to remove the rows which reference to the rows in the controlled_vocab_entries table?
Using a query to find which tables have the controlled_vocab_entry_id column I have found these tables:
table_name
---------------------------------
controlled_vocab_entries
controlled_vocab_entry_settings
user_interests
Do you know if I can remove the rows in these 3 tables, without affecting the functionality of the OJS?
from fulljournaltransfer.
Related Issues (8)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from fulljournaltransfer.