dccarson's profile - activity

I am going through my long list of inactive users and unsubscribing them from e-mail. However, this seems to me like it

Why do inactive users still receive email? We have an internal-only AskBot system, so when users leave the company, they

OK, I'll give those ideas a try. Thanks.

In my example, say I want to move from MySQL to postgres. I cannot dump a MySQL database and restore it to a postgres database, can I?

It seems that dump_forum and load_forum are no longer supported on the 0.7.x release stream.

If they are still supported, can someone explain where they have gone and how I can use them.

(0)[root@topsail askbot_top] python manage.py | grep -i forum
(1)[root@topsail askbot_top]

If they are not supported, is there any way to produce a database-agnostic dump of all the data in a running system?

For example, suppose I wanted to switch my database from MySQL to postgres. I cannot see how this is possible without having some form of dump that knows nothing about database specifics. (Note that this is not necessarily my question. I want to know the answer to the more general question of running dump_forum/load_forum or equivalent.)

Thanks.

@Evgeny, I have not looked into this problem since we last communicated. Nothing has changed. But I was wondering about commands called 'dump_forum' and 'load_forum' that you used to support as part of manage.py. I discovered these when looking for something else. It seems like this might be a better way to 'scrub' my database on the old server--and maybe it is what you meant by your comment of Aug 16, 2016 (dump/restore). I assumed you were referring to the standard dump/restore mechanism of the SQL database in question (in my case, MySQL). However, these commands no longer exist. Is there any equivalent? Is there any way to move from MySQL to postgres?

If I do everything EXCEPT loading the data from the old database, then my installation works.

@Evgeny -- this is exactly what I've been doing. All steps finish, but when I try to open the front page, I get the JSON error. As I said, when I run the 'manage.py migrate' step, it seems to do nothing for askbot.

No, I have not resolved the JSON issue. I have no idea what it is, how to resolve it. I don't even know, for sure, if the database is corrupted. But, that is my best logical guess as to why we would get a JSON error. I will try dumping/restoring the database and see what that shows. Thanks.

Is there some method of scrubbing a database that might eliminate what is possibly a database corruption issue? Any other hope of getting any help on this issue?

Any chance of help?

I am at an impasse unless I can get some help debugging this issue. We cannot abandon the database of questions we already have, but I need to update my code base. The current deployment is somehow corrupted and does not allow certain operations (altering a profile, for example). I think if I can get the new, fresh installation using 0.7.56 to get past this JSON error, then the deployment will be fully functional again. I am happy to help in debugging by gathering information. I would need instructions on what to gather. As I said before, this may be more productive taken offline, but I am also happy to post my debug info here, if that is more useful. Thanks.

The traceback can be seen here: http <colon-slash-slash> dpaste.com/09N669T

@Evgeny, I installed 0.7.56 and the installation itself was clean. This is a nice improvement--thank you. However, when I run runserver to debug and then attempt to open my browser, I get a JSON validation error. Note that I have NOT attemped to login, using LDAP or any other method. I am just trying to open the front page. Do you think we could take this offline? You should be able to see my e-mail address in your database. Send me an e-mail and then we can discuss off of this thread.

Is "markdown" allowed in comments? My previous comment is not being formatted and is therefore very difficult to read. I am now trying to put the same information in an answer, but every time I submit the answer, it does not go through. Update: I cannot submit my answer version of the comment above, no matter how many times I try. I'm not getting any error--it just does not get submitted. If you can manage to read the steps I took in the comment above, then go to the following to see the stack trace: http <colon-slash-slash> dpaste.com/0EE2GJJ (Note: I do not have enough karma to use the actual link.)

I did the following -- results in an "invalid JSON" error: """ virtualenv /opt/askbot source /opt/askbot/bin/activate git clone https://github.com/ASKBOT/askbot-devel.git myaskbotgit cd myaskbotgit git checkout 0.7.x python setup.py install askbot-setup pip install mysql-python cd /top/of/my/askbot/home python manage.py collectstatic python manage.py syncdb (note: existing db) python manage.py migrate askbot python manage.py migrate django_authopenid python manage.py runserver 1.2.3.4:8090 """ All of this worked without error, which indicates a change from my previous attempts. I always got at least one error with dependency issues before. However, when I try to open the front page, I get a ValidationError. Note that I have not tried to login yet. @Evgeny, should we take this offline?

OK. Should I be waiting for an 0.7.56 version before I try again? If not, then can you give me the exact git command to use to get the version where you are pinning dependencies. I am not a git user.

I could not respond to this answer until the site was fixed, because I was not logged in! It has finally been fixed and I was able to recover (reset) my password.

I'm trying to recover my account via e-mail, because I cannot login, which I need to do in order to ask a real question.

However, I cannot recover the account using the recovery key that is being e-mailed to me, because the key provided either gives me a 502 (bad gateway) error, or it says that the recovery key has expired or is invalid. I have tried several times, using the latest key each time, without success.

Morever, I cannot even use the "Feedback" page to voice this problem, because that doesn't work either. When I fill out the feedback form and type the captcha, it always asks me to type the captcha again. I'm about to go crazy. Does anything work?

I am resorting to (hopefully) posting this question anonymously, as I cannot think of any other way to make the web page maintainers aware of these problems.

CentOS 7 shows 1.6.10: `rpm -q python-django` yields `python-django-1.6.10-1.el7.noarch`

OK, I will try that. But is there some reason the askbot installation could not have used the Django I had installed, which is newer than what askbot requires?

I have our deployed version of AskBot running on a CentOS 6 system. It is running 0.7.49.

I noticed that pip has a newer version. I am installing on another server that also has Django running, where I can play with the newer AskBot. This second server is running CentOS 7 and Django 1.6.10. (Note that I used yum to install everything on the CentOS 7 server -- no pip.)

To my horror, the pip install askbot command removed Django from the system without even asking me. This server was running other Django applications!

Is there some way I could have avoided this? Should I have known that this was a risk?

Of the tables mentioned in the solution, I can only find the tag table. The others have presumably been changed over time.

I decided to just repair all my tables -- what could it hurt? I used the myisamchk utility instead of running the REPAIR command in mysql. This seemed to work fine -- no errors when running the utility. However, afterward, there were at least two tables that were no longer correct: django_session and auth_permission.

Not until I ran the REPAIR command from a mysql prompt did these errors go away.