I wanted advice on understanding two things,
1)If i am adding references in a separate table how do i update this table when the user opens the same page again and deletes some reference from it. I want to be able to check a page for references every single time the user opens a page and saves it after changes. In that case should i always delete entries from the referencelinks table if soem references have been deleted or is there some other way to go about with it?
2)I have created a global variable $wgReferenceIDs[] as suggeested but i wanted to know if the variables contents will get overwritten if the user moves from one page to another. Does opening a new page start a new session?
Thanks
* Trying to connect to MySQL on localhost as root... o MySQL error 1045: Access denied for user 'root'@'localhost' (using password: YES)
Something's not quite right yet; make sure everything below is filled out correctly.
what is the mysql root password?
Is it the same as the site password?
This is strange
Do you manage the server yourself or is it hosted by a third party? If it's the latter, you will not have root access and must set up users yourself. If the former, however, then you set the mySQL root password during configuration.
If you provide more details about what you're running and how you're running it, we might be able to help further.
Rob Church
On 29/11/05, Richard Gravois rgravois@yahoo.com wrote:
* Trying to connect to MySQL on localhost as
root... o MySQL error 1045: Access denied for user 'root'@'localhost' (using password: YES)
Something's not quite right yet; make sure everything below is filled out correctly.
what is the mysql root password?
Is it the same as the site password?
This is strange _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
It is hosted by a third party and I go in through cPanel which seems to be very powerful without comforting documentation.
Should these users be setup inside of mysql? The username for the site 'mysite' is mysitec and each user that I define under mysql has the suffix mysitec_
so I ran setup with
mysitec_wikiuser and got the messages:
Please include all of the lines below when reporting installation problems. Checking environment...
* PHP 4.4.1: ok * PHP server API is apache; ok, using pretty URLs (index.php/Page_Title) * Have XML / Latin1-UTF-8 conversion support. * PHP is configured with no memory_limit. * Have zlib support; enabling output compression. * Neither Turck MMCache nor eAccelerator are installed, can't use object caching functions * GNU diff3 not found. * Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads. * Installation directory: /home/mysitec/public_html/wiki * Script URI path: /wiki * Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider changing it manually. * Trying to connect to MySQL on localhost as root... o MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO) * Trying regular user... ok. * Connected to 4.1.13-standard; enabling MySQL 4 enhancements * Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider changing it manually. o Error selecting database wikidb: 1044 Access denied for user 'mysitec_wikiuser'@'localhost' to database 'wikidb'
Any help would be greatly appreciated.
--- Rob Church robchur@gmail.com wrote:
Do you manage the server yourself or is it hosted by a third party? If it's the latter, you will not have root access and must set up users yourself. If the former, however, then you set the mySQL root password during configuration.
If you provide more details about what you're running and how you're running it, we might be able to help further.
Rob Church
=================================== Richard Gravois Austin, Texas =================================== Google "end of oil" and buy a bike. ===================================
You'll need to grant that user appropriate permissions on the database, so that it can create and alter tables, insert and update rows, run selects, etc.
Rob Church
On 29/11/05, Richard Gravois rgravois@yahoo.com wrote:
It is hosted by a third party and I go in through cPanel which seems to be very powerful without comforting documentation.
Should these users be setup inside of mysql? The username for the site 'mysite' is mysitec and each user that I define under mysql has the suffix mysitec_
so I ran setup with
mysitec_wikiuser and got the messages:
Please include all of the lines below when reporting installation problems. Checking environment...
* PHP 4.4.1: ok * PHP server API is apache; ok, using pretty URLs
(index.php/Page_Title) * Have XML / Latin1-UTF-8 conversion support. * PHP is configured with no memory_limit. * Have zlib support; enabling output compression. * Neither Turck MMCache nor eAccelerator are installed, can't use object caching functions * GNU diff3 not found. * Found GD graphics library built-in, image thumbnailing will be enabled if you enable uploads. * Installation directory: /home/mysitec/public_html/wiki * Script URI path: /wiki * Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider changing it manually. * Trying to connect to MySQL on localhost as root... o MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO) * Trying regular user... ok. * Connected to 4.1.13-standard; enabling MySQL 4 enhancements * Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider changing it manually. o Error selecting database wikidb: 1044 Access denied for user 'mysitec_wikiuser'@'localhost' to database 'wikidb'
Any help would be greatly appreciated.
--- Rob Church robchur@gmail.com wrote:
Do you manage the server yourself or is it hosted by a third party? If it's the latter, you will not have root access and must set up users yourself. If the former, however, then you set the mySQL root password during configuration.
If you provide more details about what you're running and how you're running it, we might be able to help further.
Rob Church
=================================== Richard Gravois Austin, Texas =================================== Google "end of oil" and buy a bike. =================================== _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
On 28/11/05, Amruta Lonkar gtg808u@mail.gatech.edu wrote:
1)If i am adding references in a separate table how do i update this table when the user opens the same page again and deletes some reference from it. I want to be able to check a page for references every single time the user opens a page and saves it after changes. In that case should i always delete entries from the referencelinks table if soem references have been deleted or is there some other way to go about with it?
I'm not really sure what the question is here - if you want to have a referencelinks table up-to-date every time someone saves a page, then you need to update it every time someone saves the page. What actual SQL you use is up to you but basically you want to replace whatever is in the database from *before* they editted with what "should" be in the database *after* they've editted. The simplest way would seem to be to remove *all* the referencelinks for the editted page, and then "start fresh" as it were, adding the ones that should still (or newly) be there; but I'm no database guru, so that may be a dumb approach.
2)I have created a global variable $wgReferenceIDs[] as suggeested but i wanted to know if the variables contents will get overwritten if the user moves from one page to another. Does opening a new page start a new session?
Yes. The web is "stateless" - each request is completely independent. That's what the database is for ;)
-- Rowan Collins BSc [IMSoP]
mediawiki-l@lists.wikimedia.org