rockarolla
Members-
Content Count
45 -
Joined
-
Last visited
Everything posted by rockarolla
-
I have a small application that spawns several threads which produce output that I insert into the database. The output from one thread is an array and I use cursor.executemany. In the beginning I was always getting the mysql error ...I managed to resolve this issue - partially it was coming from IDLE editor and the open python shell - seems they were not unlocking the tables while open - so in order for my code to run I use to run it from the shell ... The next step to handle this was to lock the table before every insert - despite that each thread is using its own mysql connection ... At this stage the error still occurs - and this results in loss of data and CPU usage.... Any exerience related to python and mysqldb and executemany and threading will be greatly appreciated!
-
Ha a bittorrent would take you few weeks...but if you are really serious about it and have the required patience I would tell you just go to the python official web site and quickly dip trhough their tutorial, then you would need the GTK module where all the GUI comes - its actually quite straight forward and easy to utilize and they have a very good tutorial - (there are few of them to be installed for it to work...) and then you would need py2exe to compile your program to an executable windows application ...well I think i was wrong in my estim ... you'll have to devote a few months for this to work properly - but maybe first check if someone would be interested in it ... folks need fast download ...
-
HI,I've hit the grain while trying to import file to mysql database - I need to enable file permissions of the database user but this seems not possible with most of the hosting providers. The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only allow privileges on table querries but you cannot grant host file privileges to the database user - which makes querries like:"LOAD DATA INFILE 'filename' INTO TABLE tablename..."impossible to use - you'll get the access denied errors ...Any workaround will be greatly appreciated!
-
How To Create A PHP Based Hit Counter With MySQL
rockarolla replied to iGuest's topic in Programming
only to mention, I think the word unique is not allowed... I would prefer to make the counter using session...just in case cookies aren't allowed and because using cookies is not always safe. I think they do encourage ppl to use session for cookies. -
REsolved. The problem was the php.ini file - the automatic configuration done by mysql isn't working properly. You need to add some extension caluses in the php.ini file to dynamic libraries that aren't present explicitely....I found an answer - rather a workaround here: http://www.tanguay.info/wamp/installPhp5.php5?step=15 simply add the lines to php.ini: extension=php_mysqli.dll however, this libabry doesn't exists - its fictious in that it can be obtained by renaming php_mysql.dll to php_mysqli.dll (you may find them in the ext folder of your php installation directory) I have them both in the extension clause - now cannot be bothered as to check which one is necessary(some forums say both anyway). I don't know how such a bug can exists? Maybe its a third party stuff interested in promoting their software...
-
I bumped on this combo server applications but I preferred to use the raw distributions...I would appreciate if you could check for me the config files if there are any (e.g. httpd.conf of Apache and the php.ini ) and give me the lines including mysql, safe there are no personal or sequrity issue therewith!Thanks.
-
I have problems running PHP MySQL function in a windows set web environment. PhP scripts are executed but if I try to use mysql connect and other like functions I get a blank window (while using the browser).The command line client is working...I've added the path to libmysql.dll and the extension=php_mysql.dll in the php.ini.
-
file based counter may jam - sometimes it wont be able to overwirte the data - when many visitors navigate to your web. The other problem is if you ain't got permissions to open a file on your server...hence host dependent.
-
Thats my point. The database table has an user/pass so it might not be accessible for a bot or it might be...I think they ``crawl'' a particular site by ``virtually opening'' it and then check the content...at least this is my experience...as I really need to know this I'm making some crawling around too to become an expert... see how if I'll share it ... here are the advises given by G: https://support.google.com/webmasters/?answer=40349
-
Hi,I have made my web site solely stored in a SQL database...that will say if I need to load a page I take it our from the data base and then display it. My question is: is any searcg engine able to ``crawl'' into my web site content?I would appreciate some info so that I can change the way my web works.
-
Well nice tutorial - am Example! But when do you need to write HTML code with a PhP chunk? To me it seems much easier to have a text file with the HTML file - call it template - and insert in it only the new elements I need dynamically dependng on a conditional statement.Another way is - if you want to use PhP to write your HTML code is to read the above template file in an array (or even from the database) and insert it at the place where you need it with a simple function.Well thats my view...I used to use C code to create LaTeX graphics in a similar manner and I am preparing to generate the PhP code for my web site like this.Actually if you want to save writing, you have to use loops - looping is the power of the computers!
-
Lost Connection To Mysql ,..., System Error: 111 In
rockarolla replied to rockarolla's topic in Programming
I don't think so. Here is my code. Its a very simple code just to see if I can ever establish a connection with my database: function open_connection() { $host='localhost:3307'; $user='any'; $db='my_db'; $password='my_pass'; $conn=mysql_connect($host,$user,$password); mysql_create_db ($db,$conn); mysql_select_db($db); return $conn;} If I call this function within my file I get the error: Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in I've looked about several forums and I didn't get any concern to my code. Also I tried using mysql_pconnect() as someone suggested that the problem maybe dropping connection, but it didn't work as well. I don't have any rights to configure neither php nor mysql. So I guess the provider doesn't want anyone to connect to their database... On the same host I cannot use code like this: function add_hits(){ $opFile = fopen ("counter.txt", "r"); $handle = fread ($opFile, filesize ("counter.txt")); fclose ($opFile); . . . so I think at the end that this is a server issue. -
Ehhh if I check the system requirements I get somehow disharted: I ain't sure if I comply with thi requrements...I don't know even how to check it under Windows. Anyway I'll try it out. I take the challeges of the freeware.Thanks
-
Is X-Men Possible With Genetic Engineering ?
rockarolla replied to Darkwolf11235's topic in Science and Technology
Not only lost limbs, they are doing quite some stuff for growing new organs for transplantation. But it seems not that easy - and thats because the experiments with anumals and ppl are forniden. I have some suspictions that at some places these is not the case. Probably secretly experiments of all kinds are carried out and not for the above mentioned noble goals...The best thing of course wll be to battle death I see myself as immortal -
i,what is the best freeware graphic design program - for web design application (like buttons, background and etc.)
-
How many of us believe in the existence of alien living forms? Well most of you will be on he same opinion - ALF exist and we believe that one day - soon or later they will come or we will happen to meet them. How will they look like? This topic has been discussed n details by the late astronomer Carl Sagan. I would strongly recommend his book - very well known to the older generation mostly due to the TV series he directed - which is result of his research on popularization of science and his search for alien forms.The most interesting moment of course will be the encounter itself - how all those ppl - leaders politics and etc will react - or what will be the code of beaviour with the aliens - that will bring whole lot of fun to the ordinary ppl. I recall scenes from the movie Mars attacks - and I think on formal level it will be this way. So lets hope that the first encounters will take place in a loose informal fashion so that we will avoid shame and the embarassment.Well but - shall we be ever able to meet another civilization? At this moment it is very unlikely that we won't. The means of traversing long distances we have are extremely primitive...we are restricted by the speed of light! Even if we manage to travel at this speed we won't be able to reach very far - not within a life span of the senders - nor of the passangers...seems that we are prisoners if not of the earth then of the solar (inner solar) system. But there is light in the tunnel...according to some calculations and hypotheses we might be able to travel in time and space in an instantaneous manner! This might be all possible at the vicinity of a Black Hole through a sleevs called Worm Holes...At the present moment this has been seenn in the highly abstract solutions of the Einstein equations...we are to wait a bit longer to witness it ourselves...
-
According to my surroundings it is Windows 95. May vote goes for 98 although to what I have understood the ``core'' of all versions after 95 are all the same. The decoration however has evolved to what we know today .
-
Well under windows the best is to use the old BCC (Borland) C and C++ compiler...I still have a copy of it - it is compact and proved.
-
My Summary Of Vista Bugs User summary
rockarolla replied to Ronel's topic in Websites and Web Designing
Thts only ten percents of the nuberr of reasons you have to go for Vista...well there is an improvement...maybe you just powerd on your pc ? What will be when you use Vista for an hour -
Send report for all the problems ... the more reports sent the more updates will come thats the way it works...Though I still read some positive feedbacks for this OS...the worse is to come - when other software producers will make their stuff running only on the last version of this OS...
-
100 Reasons To Use Windows Vista No, really??
rockarolla replied to FirefoxRocks's topic in Websites and Web Designing
The problem is that in most of the cases you are obliged to buy it. Some retailers doesn't sell their computers without OS. So want it or not you got to get it...I am particularly irritated with designed for ........ sticker - so ITS EASIER TO DESIGN THE HARDWARE TO SUIT THE SOFTWARE -
How To Make Windows Xp Faster
rockarolla replied to robert2411's topic in Websites and Web Designing
Well I do agree with your saying but sometimes the requirements of the OS exceed the pocket of the middle class - and this only to see some special The Wizard of Oz effects. I don't know some of the essential processes to require a lot of hardware - it is all the same story - you want more visual effects - you need more resources...wy go for that? The answer is simple... -
You need not memorise anything but a few lines to start your server with Linux - thats why Linux is good for servers...with the proprietary OS you would need to let all users wait while you restart and debug your system...Linux has as good a GUI as any other OS so with a few lines you'll be running a server and have access to updates of any kind to keep your server up-to-date and safe.