We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Garbage after clean install | Forum

Topic location: Forum home » Support » General Questions
LetsDo
LetsDo Dec 17 '14
I just installed Oxwall locally to test how this appear on my site, now I can confirm that after a clean install a lot of yunk is left on the .xml files for the English Language Pack.

Examples: (Links to a website comunidad rios de agua viva)

LINK /xn/detail/u_1s5imcyo0dxha

{text key='base+questions_question_sex_value_4'}

---

LINK /xn/detail/u_00p7h97i4d6e5 {text key='base+questions_question_36e39f917cbcf4fb10aa753186ced60d_value_8388608'}

-----
Like those, a lot of them, and some others like:

13 {text key='base+questions_question_field_f601014ed0ceba2d4e25606de1992eba_value_4096'}

A lot of different numbers as well as:

bbbbb bbbbb {text key='base+questions_question_field_f601014ed0ceba2d4e25606de1992eba_description'}

Well, I think you get the idea.

I'm using Oxwall 1.7.2

What is all this?



LetsDo
LetsDo Dec 17 '14
So apparently, all this garbage comes from

oxwall-1.7.2\ow_install\files\install.sql

Is there a way to get a clean install.sql file I have not clue why all that junk is in there.
ross Team
ross Dec 17 '14
Let's do, yes we are aware of those junk empty keys and values, unfortunately to delete them completely is not possible for now, you need to write a script in order to detect which key is used in the database and code as well, if it's not then delete it. 


We plan to do that in the nearest future in the meantime you can delete them manually: http://www.oxwall.org/forum/topic/17416?page=1#post-87459

LetsDo
LetsDo Dec 18 '14
Thanks Ross. Yes for now what I'm trying to do is, exported that Table from the DB into a local DB, did some cleaning and now I exported the more clean version of that table and I'm going to add it (replacing the one with junk) on the install.sql file.

I would love to know how to "write a script in order to detect which key is used in the database and code as well" because that's my main fear, I don't want to delete things that are really needed, but for most empty entries and the garbage like "asdas" "qqqqq" and that stuff I'm sure there is no problem, also I deleted a lot of sports entries, hair colors and so on.

Even when I finally going to use "Spanish" as language for my install, I want to start with a clean install of Oxwall but it seams it's not possible right now.
ross Team
ross Dec 18 '14
I'm sorry but we do not provide assistance on script development. You need to hire a programmer (you can do that here: http://www.oxwall.org/market/specialists) or do that on your own if you're good at php and mysql
Norias
Norias Feb 10 '15
Quote from ross Let's do, yes we are aware of those junk empty keys and values, unfortunately to delete them completely is not possible for now, you need to write a script in order to detect which key is used in the database and code as well, if it's not then delete it. 


We plan to do that in the nearest future in the meantime you can delete them manually: http://www.oxwall.org/forum/topic/17416?page=1#post-87459


Please provide us a clean english language we can translate in our own language because it is very complicated to do that with all those bad keys in "Base"


Is it very hard to create such a cleaner script ? Maybe there is in this forum a marvelous oxwall user who know how to do it ? ^^
Just want to know what is the "nearest future" ? In the next oxwall version ? Because if it's coming soon i will wait, if not i will try to find time to clean by myself.
Last question, is there a impact on the performance of those too many keys ?


Thanks all lot for your explanations :)

ross Team
ross Feb 11 '15
There's no impact of those empty keys on the software performance. 

I can't tell you for sure when exactly those keys will be cleaned as Oxwall is a small team and we have more important plans, issues and cases on our hands right now. However we do our best. Just give us sometime to implement this. 

Norias
Norias Feb 11 '15
ok, thanks !


As there is no impact I will keep those key, and forgot them ;)


Take your time to make Oxwall the best social cms !

ross Team
ross Feb 11 '15
Thanks. 
macallister
macallister Jul 25 '23
This blog discusses the importance of dumpster rentals in managing waste effectively. Whether it's for home renovations, events, or commercial purposes, Dumpster rentals offer a convenient and responsible way to handle trash. I really like the information shared on this blog.