Thanks,
We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
SQLSTATE [23000] Error [Solved] | Forum
Donamix
Jun 10 '13
Hello, please help me fix this, it's URGENT.
The Forum post is edited by Alia Jun 17 '13
Leader dave
Jun 10 '13
looks like you were either trying to reinstall or import the table without first clearing your db. You cannot install a key over a duplicate key, that means that if the table data is there already then you cannot put the same data ontop of it.
What is it you are trying to do?
The Forum post is edited by dave Jun 10 '13
Leader dave
Jun 10 '13
ok, just a word of advice for your security, when you post stuff like that take out the section that says your username after /home/username
replace username with xxxxxx for your security, noone needs to know your username :) you an leave the rest just remove the username
prob will need a team member for this.. There should be one online now... They should reply soon..
The Forum post is edited by dave Jun 10 '13
Leader
Donamix
Jun 10 '13
did you turn on debug mode or did someone else?
I turned on debug to see the error, from the screenshot
Leader dave
Jun 10 '13
ok i did send them a message for you :) so someone should be here in a bit, maybe even Aliia or Daisy or Ross..
Donamix
Jun 10 '13
ok i did send them a message for you :) so someone should be here in a bit, maybe even Aliia or Daisy or Ross..
Thanks a lot. :)
Team Alia
Jun 10 '13
Donamix, I have checked original Oxwall source code and it doesn't contain the code specified in your screen shot ( for example, action_set_dao.php, line 152).
Have you modified source code of the newsfeed plugin?
Have you installed any plugins that are connected to newsfeed? ( for example, newsfeed auto-refresh)
Have you modified source code of the newsfeed plugin?
Have you installed any plugins that are connected to newsfeed? ( for example, newsfeed auto-refresh)
Donamix
Jun 11 '13
I did not modifie source code of the newsfeed plugin.
I only made a plugin that is connected to newsfeed.
Team Alia
Jun 11 '13
Donamix, also which version of Oxwall are you using?
And when do you get 500 error? Just by visiting your homepage?
Have you tried to deactivate your plugin?
And when do you get 500 error? Just by visiting your homepage?
Have you tried to deactivate your plugin?
Donamix
Jun 11 '13
I just tried to deactivate the Newsfeed plugin, the site worked.
But when i deactivate my plugin it's not working.
Team Alia
Jun 12 '13
Donamix, I don't know which plugin you have installed. I think that whatever your plugin does, it overwrites original code. Is it your own plugin? Or one from the Store?
Depending on how this plugin was developed, deactivation might or might not help.
Will you be able to uninstall it completely?
Depending on how this plugin was developed, deactivation might or might not help.
Will you be able to uninstall it completely?
Donamix
Jun 12 '13
Aliia, it is my own plugin.
Please check your pm i sent you a demo link to see the plugin.
Yes dear, i have uninstalled it completely
Still got the Error.
Error 500
Internal Server Error.
It's really urgent my site been down for 2 days.
Btw, thought i'd let you know, my plugin does not overwrites original code.
The Forum post is edited by Donamix Jun 12 '13
Donamix
Jun 13 '13
Donamix, I don't know which plugin you have installed. I think that whatever your plugin does, it overwrites original code. Is it your own plugin? Or one from the Store?
Depending on how this plugin was developed, deactivation might or might not help.
Will you be able to uninstall it completely?
Have you got any updates for me?
Please as a mentioned it's urgent,
If there is no solution let me know.
I'll just delete the Newsfeed plugin and lose all data.
Nothing else i can do, as i need this urgently
Now my site been down for 3 days!
Leader dave
Jun 13 '13
maybe you should try to find that duplicate key an remove it, that would at least get your site back. Or you can flush your DB and import your db from a backup before this happened. You do have a backup of the DB dont you.
Donamix
Jun 13 '13
Hello Dear,
I don't want to say maybe i'm afraid of losing Newsfeed data.Do you think if i duplicate that key it will help?
My site is back man, just Newsfeed plugin is de-activated.When ever i activate Newsfeed plugin i get the Error.
I don't really know if i have a backup of the DB.I have a VPS Cloud Server.It only Saves Backups from 2 weeks and from 2 Days only.
