Search the Community
Showing results for tags 'Database'.
-
Hello to ALL of you! This is my very first PW ... and I need help. I use Wordpress most of the times... So, I am hosting at Dreamhost. All test went well (see snapshot attached), however, when creating the DB I got these 2 lines: Database connection information did not work. SQLSTATE[HY000] [2002] No such file or directory I tried it with DN name: "localhost" and with "db.mysite..." as well. Same result. I think a more detailed error message, with reference to "how to resolve it" would be useful... So, what should I do now? How to go on? Thanks a lot, Tamas
-
Hello, today I run into an interesting problem. Everytime when I trie to add an field it says SQLSTATE[HY000]: General error: 1214 The used table type doesn't support FULLTEXT indexes. I think the problem startet after I installed „formbuilder 0.2.5”. Had anyone here same or equal problems? Today I switched the database from one hoster to another hoster (the problem appears on both of them). Henning I use PW 2.5.29 -
I have a friend who uses Silverstripe, and he was telling me about the Data Objects and the ORM it uses, for things like "has many", "one to one", "one to many" relations etc. Maybe i'm not thinking about things correctly, but in the Processwire world, would a Page essentially be a data object? Just want to get my head around how to think about structuring a web application in Processwire. I'm familiar with traditional MVC (rails, code igniter) based structures. The API may already enable this kind of functionality, but i was wondering if not, would Processwire ever get an ORM? or can an ORM be bolted onto Processwire? If anyone could help me figure this out that'd be great. Thanks
-
Hi! I am redesigning my site and set up a development version of the site (plain copy) using the same database. During the redesign process I became interested in the CroppableImage module, which requires the dev version of PW. I upgraded the files in my development sites, but want to check with you before I start installing the new modules in the test version: Can this cause problems with the production site as long as it isn't using any of the new fields/modules? //Jasper
-
Having a strange issue where i keep getting MySql 2006 errors (database gone away) on url http://mp-arts.co.uk/?/ for user ? I've check the PW logs and something is hitting that url ALOT, is there anyway to kill the access to that url?? Thanks
-
How can I get the index type of a mysql database table with pw-api? The Following doesn't work. Why? $table = 'pages'; $column = 'pages_id'; $sql1 = $db->query("SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '$table' AND COLUMN_NAME = '$column'"); $options = array(); while ($row = $sql1->fetch_array()) $options[] = $row; var_dump($options); // return empty array
-
Hi, Processwire makes efficient use of mysql - every field is a table and field-specific tables are joined on demand. However, joins are used nonetheless, especially in performing queries for $pages->find("selector") and related db-querying selector functions. So queries for $pages->find(field1=value1, field2=value2, field3=value3) will join field_field1, field_field2 and field_field3 tables. In this case, does it make sense to use graph databases (such as neo4j) compared to mysql? With data being connected now more than ever and with all the hype around graph databases and neo4j, will we see a potential support for graph databases in future releases of processwire?
-
Hi there, I have recently transferred my Processwire to a different host. I have created a database and imported to the new host server and have transferred all the files Processwire. I have also created a database user and updated the config.php file with the necessary information and I am getting the following error in debug mode: Fatal error: Exception: DB connect error 1045 - Access denied for user 'admin'@'192.249.113.81' (using password: YES) (in /home/admin/public_html/wire/core/ProcessWire.php line 96) #0 /home/admin/public_html/wire/core/ProcessWire.php(45): ProcessWire->load(Object(Config)) #1 /home/admin/public_html/index.php(183): ProcessWire->__construct(Object(Config)) #2 {main} in/home/admin/public_html/index.php on line 214 This error message was shown because site is in debug mode ($config->debug = true; in /site/config.php). Error has been logged. Any clues of what is happening? Can anyone please help me? Thanks
-
Hi, the AdminThemeReno has mysteriously disappeared from the admin. it is in the wire modules, and the database modules table, but absent from the modules listing.. it has basically vanished; I tried updating to the latest dev to see if that would fix it. The problem seems to have started when i went into Modules Manager and the version was older so there was a json error; then right after reloading the page, the theme flipped back to the regular theme, and then the reno disappeared..; i'm not completely sure if modules manager was the source of the issue; I'm guessing some database corruption? not sure where to start troubleshooting this, but would really appreciate any help or advice. What do most people do when you hit a 'dead-end' issue like this? Is there some way to check the database for some misconfiguration? Should i delete the modules entry in the DB? not sure if this is related, but if i uninstall the default theme, i get this error: Modules: Module 'AdminThemeReno' dependency not fulfilled for: AdminThemeDefault and also if i try to place the default admin theme module into the /site/modules/ then i flip back to the legacy admin, and there is an error asking which one, but if you click on that and go to the module settings, there actually isn't any option to specify which folder to use; it ends up using the site version.. also getting strange errors... [14-Feb-2015 19:46:11 America/New_York] PHP Notice: Trying to get property of non-object in /home/someuser/dev/site/modules/ModulesManager/ModulesManager.module on line 820 [14-Feb-2015 19:46:32 America/New_York] PHP Notice: Undefined offset: 0 in /home/someuser/dev/site/modules/ProcessDiagnostics/DiagnoseModules.module on line 43 [14-Feb-2015 20:12:27 America/New_York] PHP Notice: Undefined index: AdminThemeDefault in /home/someuser/dev/wire/core/ModulesDuplicates.php on line 284 [14-Feb-2015 20:12:27 America/New_York] PHP Notice: Undefined index: AdminThemeDefault in /home/someuser/dev/wire/core/ModulesDuplicates.php on line 287 [14-Feb-2015 20:12:27 America/New_York] PHP Notice: Undefined index: flags in /home/someuser/dev/wire/core/ModulesDuplicates.php on line 287 [14-Feb-2015 20:14:48 America/New_York] PHP Notice: Undefined index: AdminThemeDefault in /home/someuser/dev/wire/core/ModulesDuplicates.php on line 284 [14-Feb-2015 20:14:48 America/New_York] PHP Notice: Undefined index: AdminThemeDefault in /home/someuser/dev/wire/core/ModulesDuplicates.php on line 287 [14-Feb-2015 20:14:48 America/New_York] PHP Notice: Undefined index: flags in /home/someuser/dev/wire/core/ModulesDuplicates.php on line 287 [14-Feb-2015 20:15:12 America/New_York] PHP Notice: Undefined index: AdminThemeDefault in /home/someuser/dev/wire/core/ModulesDuplicates.php on line 284 [14-Feb-2015 20:15:12 America/New_York] PHP Notice: Undefined index: AdminThemeDefault in /home/someuser/dev/wire/core/ModulesDuplicates.php on line 287 [14-Feb-2015 20:15:12 America/New_York] PHP Notice: Undefined index: flags in /home/someuser/dev/wire/core/ModulesDuplicates.php on line 287 thanks!
-
This is my 3rd post here. I have to admit that I become highly addictive on PW after painful usage of Joomla which I almost mastered, and really need to thank to Ryan for this drug! During registration process, I wanna assign values on an automatic way. Well, I'm stucked and need your help. Successful registration: new user is created, new pageInfo page is created (let say, user profile) using user_info template which contain title, headline and userinfo repeater with fields like firstName, lastName, etc. user will be redirect to his userinfo page after successful registration. I can grab repeater values (which I typed directly via Admin panel) but I don't know how to add values automatically during registration proccess. I don't even know if I have to use repeater or not... :/ (plan was to track user info changes; this can be redesign later to track only email or username changes but atm let say that I wanna track all changes) register.php <?php $headline = "Registration form"; include "./register.inc"; $errorMessage = ""; if($input->post->register_submit) { // process submitted register form $first_name = $sanitizer->text($input->post->first_name); $last_name = $sanitizer->text($input->post->last_name); $display_name = $sanitizer->username($input->post->display_name); $email = $sanitizer->email($input->post->email); $password = $input->post->password; $password_confirmation = $input->post->password_confirmation; if($password!=$password_confirmation) $errorMessage = "<br><p class='alert alert-danger alert-error'><strong>Error!</strong> Register failed, please try again.</p>"; $p = new Page(); $p->of(false); // sets output formatting to false in order to change field values. $p->parent = $pages->get("/users"); $p->template = "users"; $p->title = $display_name; // sanitized your value from form and sets to title //$p->other_field = $sanitizer->text($input->post->other_field); $p->save(); // save the new page $p = new Page(); $p->of(false); // sets output formatting to false in order to change field values. $p->parent = $pages->get("/users/$display_name"); $p->template = "user_info"; $p->title = "UserInfo"; $p->save(); // save the new page $pui = $pages->get("/users/$display_name/UserInfo"); foreach($pui->userInfo as $info) { $info->of(false); $info->set("firstName", $first_name); $info->set("lastName", $last_name); $info->set("displayName", $display_name); $info->set("dateCreated", date("j F Y H:i:s")); $info->set("dateUpdated", date("j F Y H:i:s")); $info->set("email", $email); $info->save(); $info->of(true); } // now add the user $u = new User(); $u->of(false); $u->name = $display_name; $u->email = $email; $u->pass = $password; $u->save(); $u->of(true); } ?> That's all for now...
-
Hello and thanks for any help you can provide! I know I'm in way over my head, but Processwire has me drunk on power. I know so little and yet so far I've been able to do pretty much everything I've wanted to, including all sorts of crazy admin features that until recently I'd thought were the sole purview of programming ninjas. Anyway on to my problem: thanks to PW I've picked up a lot of PHP, but I know next to nothing about MySQL. So you can assume utter-beginner level knowledge, but also full readiness to learn what needs to be learned to get the following done: I have an existing database that has lots of data I want to use to model PW pages on. How would I build a PW site using some of the fields/tables in this database? The PW database would need to change and re-model this data in various ways. This existing database also keeps changing. How can I stay in sync with the database, even while my database no longer looks like the existing database (cause my data changes too)? Where can I start learning about what I need to know to start doing this and slowly get on top of it? Please point me in the right direction to start investigating - modules, books, tutorials - any input is welcome and deeply appreciated. Thanks again. -
Ok, so I have a new project that has PW as the selected framework of choice. Here are some of the constraints I'm working with: 1) The corporate database will replicate all the other branches data. 2) Each branch will have it's own web and database servers, thus run their own instance of ProcessWire and all data will be saved within the intranet. 3) Each branch will be able to access the other branches install via VPN. The web servers/code base will be synced using Git. 4) Each branch's database server will have a Symmetricds node installed. Via VPN, each node will push/pull to the corporate node, keeping the databases synced. Symmetricds allows for table and column specific updates so the whole db won't be getting replicated on each pass. 5) The database sync needs to be bidirectional, as in Multiple Master Replication. Reason being, the company plans on having certain departments add pages directly to the corporate account that will affect the other branches. For instance, the Human Resource department will handle adding/removing users and maintaining records on them. Each user created by HR will need to be able to access any branch's data when on the VPN. So user pages would need to be pushed to the branch db's. Here's what it would look like: // Inside Branch 1's Building: Client 1------via intranet---------------Web Server 1-----DB Server 1 // Connecting to remote Branch 2 from Branch 1 Client 1------via internet (VPN)------Web Server 2-----DB Server 2 // Database syncing DB 1-------------via VPN-------Corporate DB 1 and vise versa (bidirectional) DB 2-------------via VPN-------Corporate DB 2 The schema between all databases will be exactly the same. So, initially, my game plan was to change mySQL's auto_increment_increment and auto_increment_offset on each db instance, keeping the different branches on separate indexes when pages and fields are stored. Hopefully, this would cause a mostly conflict free environment. Also, this limits my approach on dealing with expansion. Once 9 offices are established, I'm going to have to start getting creative with the increment patterns. I suggested a cloud based approach but they insist on using their current infrastructure. My other idea was to write transaction and conflict rules into Symmetricds and allow it to make changes to page ids, etc and any references to such in the db. The real danger is when there is a mass building of pages when the VPN is not available, like an internet outage. Once the internet is back online, there could be a lot of pages that need to be replicated; with the likelihood that many pages end up with the same exact page id's, etc. Anyway, does anyone here have any advice as to what they would do? I'm open to hear opinions of what others have done in this same sort of scenario before I choose my path.
-
A company approached me wanting to convert their paper-based ways of collecting customer information into electronic. Reason being they want to instead use a tablet (in office) and have them fill out everything electronically in order to prevent readability / processing errors and also offer the ability to fill out on their website. The type of information such a company needs from their client is pretty intense and detailed. Customers are filling out multiple documents disclosing personal information, not only about themselves, but also about the defendant - everything from vehicle registration, address / work history to personal identity to the fullest extent) - things like social security numbers, etc. It seems there isn't a sensitive data question not being asked. Not only that but they are also disclosing credit card info (for payment). It's pretty monumental in terms of data. I never accepted the project and said I'll look into what's possible but out of curiosity and being the curious type I am, I have already built a mobile-responsive / electronic version of their entire 200+ question form(s), complete with task completion status, page summary, auto-complete, validation, terms of service. It's damn beautiful but that was the easy. Even though I like getting my feet wet, I am wondering if I should continue or if it's even worth the headaches, not to mention the technical hurdles. The questions I am wondering are numerous (and for understandable reasons). I guess the top would be: I know all this data has to be encrypted and secured to the highest extent. I don't know what's involved or how deep it can get. I do know the risks and the laws governing storage of such sensitive data and also the penalties for the company if it gets stolen. So I'm hesitant to even take on this task for that reason alone; especially since I'm still very much a PHP / programming beginner (although devoted). I don't want to major f*** up I was thinking storage would be on the web host instead of some sort of in-office database? An online back-end would have to be created to retrieve information so that the company then could process it (they wanted it as a pdf). They need some way to retrieve the data. They need to be able to charge / have access to the credit card again at a later date so integration with a payment processor needs to be implemented, correct? I am asking more what direction / route / study material I should look into (first steps) more than specific procedures because I understand it's very involved. If I can't tackle this now, I would like to learn so I can accomplish this in the future because building, integrating and deploying things of this nature is where I would like to go. Just curious on your thoughts. Thanks everyone -
Hi all I had a look to the processwire database and it is getting quite messy as not all developers seem to follow some kind of basic naming conventions. i.e. cache (is OK) CommentRatings (is not OK imho as Big and small Letters and beside this it does say nothing about if it is a field or a page or whatshowever) fieldgroups (is OK) ... than we have hana_code (is OK) link_ ... mb_ ... modules module_ ... pages_ ... page_ ... ProcessFieldChangeNotifier (why not process_fieldchangenotifier?)) ProcessRedirects (why not process_redirects) ProcessTrashman (why not process_trashman) process_ ... session_ ... ShoppingCart (again Big and small letters. IMHO it would be better to have shop_cart and than shop_order etc. ....) templates textformatter_ ... users_ ... version_control_ ... ------ To keep the database somekind logically and easy to search and look at it would be great to have some naming conventions in place: What Naming Convention exist in the ProcessWire? Are there any? fields_ pages_ page_ template_ process_ textformatter_ version_control_ users_ What about some additional ones like ? apps_ i.e. apps_commentsratings apps_shoppingcart etc Thanks Andi
- 2 replies
-
- 1
-
-
- Database
- Naming Convention
- (and 1 more)
-
Use ProcessWire in a MVC like fashion, or just use pages?
tehandyb posted a topic in Getting Started
Hi I am looking into ProcessWire to build an application. I am used to building applications that have db models separated out, which is nice and organized for building the application. I would also want to separate out a lot of the logic for the application(more in a Model View/Presenter fashion) and have seen some people are doing MVC with ProcessWire. But I wonder if I use pages, would this be similar to having models? I read somewhere that Users are pages in processwire, and user attributes can be fields of these pages. So maybe pages are one of the magic ingredients in PW? Can/should I do the same for other db models in the application(use pages as the models), or would I better be served by integrating an MVCmodule into PW, or using Laravel with PW? It's starting to seem like PW is a very different type of framework and can do all the MVC stuff, but in a slightly different paradigm, and that Pages are like the model, and Templates are the View/Presenter/Controller. And you could separate out the controller if you wanted to create some classes and implement some routing if you wanted. -
I'm creating a site to showcase project work from my students. I know this is a breeze with my conventional SQL database and ASP.NET tooling but hopefully I can work this out in Processwire. Can anyone comment on whether this plan holds water? Each Project has: Name Student members (1-4) n photos or videos or audio clips Obviously a page with a backing template with the appropriate field types works here. However, the members need to be selected from a separate list of Students. This suggests a PageReference field I reckon and a repeater to handle 1-4 Students. I have student details (ID & Name & Programme of Study & Yr of Study) in CSV file so guess I can generate pages from that file to create a collection of Students. I may want to filter Projects by 'Programme of Study' (from Student page). Should I create Student pages as a child page of 'Programme of Study' with maybe an in-between parent of 'Year of Study'? I might also permit access to the Project page only to those students who are members. So maybe setting Students up as users is the better way to go? I guess I'm looking for guidance around how to implement foreign key relations as you would normally do for a database. I'm guessing there are performance issues around the kind of querying I might want to do but there are hopefully some rules of thumb around establishing relations between entities (pages) in Processwire. Thanks, John
-
Hi everyone. I really need help /guidance knowing if this can be done and what direction I need to take. I have a week to develop and deploy a front end music catalog. I have some limited experience with PW, developing only very small sites....nothing of this magnitude and complexity. If you could guide me to the technologies I need to look at and point me in the right direction, I will be very appreciative. I need to create a searchable page for essentially a music catalog which will pull information from artist's pages. Each track / entry needs to have a number of sections associated with it (track title, length, genre, publisher, songwriter, mood), and maybe an external-pointing link to lyrics. Each line / track will also have to have a play button and link to the music purchasing page for that particular artist. All those sections / fields listed above need to be able to be searched / filtered as well. Easier if I just show you a link to something similar. http://www.noideaband.com/songlist/ That is a WP module and I want that basic look / feel / functionality. It needs to basically pull all of the music files / products from individual pages and into the catalog I don't know. Maybe I am in over-my-head but I am really not sure where to start :/ So here is the site structure I must have: Home - Music Catalog (contains all the songs/artists on the website. This must be a searchable database front-end) - Artists -Artist Name (contains info about artist, etc) -Album 1(contains individual tracks, bio, genre, lyrics, etc) -Album 2 -etc Thanks in advance for whatever information you can bring to the table.
-
Good morning. I'm having a problem with my big PW site. It stopped responding less than an hour ago (except for the 500 Internal Error message). Here is what the error log says: 2014-03-17 13:07:50 ? https://wwwudev.cac.washington.edu/?/ Error: Exception: SQLSTATE[HY000]: General error: 1194 Table 'modules' is marked as crashed and should be repaired (in /nfs/bronfs/uwfs/info/wwwudev/world/uaa/advising/wire/core/Modules.php line 251) 2014-03-17 13:13:30 ? https://wwwudev.cac.washington.edu/?/ Error: Exception: SQLSTATE[HY000]: General error: 1194 Table 'fields' is marked as crashed and should be repaired (in /nfs/bronfs/uwfs/info/wwwudev/world/uaa/advising/wire/core/WireSaveableItems.php line 141) 2014-03-17 13:19:02 ? https://wwwudev.cac.washington.edu/?/ Error: Call to a member function has() on a non-object (line 36 of /nfs/bronfs/uwfs/info/wwwudev/world/uaa/advising/wire/core/Users.php) I repaired the modules and fields table but now I'm getting the last error and I don't know what is happening. The site is on a shared server; I checked to make sure I have lots of disk space. I don't know what could have changed this morning; my next step is to ask our network technicians.
-
Hi, I'm using the Database Session Handler the first time with a site and have noticed that the no more used sessions get not deleted automatically. They get deleted when I'm logged in and go to Setup -> Sessions. Is this normal behave or is there something wrong with the server the site is running on. How is the deletion triggert? Can I do something together with lazy-cron?
-
When I get in contact with processwire after a recommendation of a friend the first step after installing was a look in the database. Why? I had bad experiences with a shop-system I used, which ended up in digging and modification of the source code to make it work properly. Finally the biggest problem was the database with its questionable structure and data redundancy. I said goodbye to the shop-system after. With processwire I felt immediately in love because of its super slim and clear structured database without redundance of course from which results a lot of opportunities to grow. But since I use multilanguage support in processwire it makes me a little gripes when I see the way of Language Implementation in the database. About the conventional structure as an example: users are stored in pages and passwords are stored fields 'field_pass' which refers to the page (perfect) Structural changes since multilanguage support: pages and fields either have data (information about language) stored in column titles like 'name1007' or 'data1007' (not really perfect) What happened while making processwire multilingual? The tablefield in the database 'name' in table 'pages' wasn't unique anymore. 'name' from now on would have to be a field 'field_name' like 'field_titel' with its own databasetable. Same to status. The status of a page should be stored in 'field_status'. Possible solution: There exists already a field 'field_language' which stores the language of the page 'user'. This field could store easily the language of every page. Every page in every language should have its own database entry and unique id, even the rootpage with parent_id '0' should have this. All name and status columns should be outsourced to fields. Language relevant columns like 'data1007' in fields are obsolete. As a result every field becomes multilingual automatically, because it references to a unique site. I know that many people Ryan first of all have spent a lot of time and work to make this great system available. And I have a lot of respect before this people. I am happy to use processwire and I love it. But since I run in problems when I decided to switch an alternative language to the default language burrowing around in the database I started to think about some facts. I am pretty sure processwire will run in problems following the pursued way. On the way making processwire to the worlds best CMS the database as the heart of the system should be young, healthy and proper.
-
Hey How to make a back up of my processwire database, except of phpmyadmin.
-
I copies the Skyscrapers field entry data almost to the 'T' when creating my PW project. I created new pages/subpages for the drop down data to choose from and now I want to give a new page the option of selecting from one of those drop down of those categories. All looks good. I go from a drop down tree list of my pages, select the page I want to categorize the page with and then hit save ... but nothing stores in the database and when I come back I have to select it again. Also if I choose 'select' instead of PageListSelect I see a drop down containing nothing in the page when creating a new one. Is there some kind of programming needed to be able to store PageListSelect data? Thanks.
-
I did a big beginner mistake. I've deleted MAMP PRO to use XAMPP and in the process of the uninstalation of MAMP PRO I deleted all my databases... Fortunately my projects are already live so I have a working copy on the FTP of my client. I would like to have all this data as it is online so it works local on my computer. This is working with a processwire CMS, the url is http://www.fem-k.com/ if in need... Please let me know how to solve this problem so I can go on playing with processwire on my computer. Thank you very much!!!
-
Hello everyone, I'm a PW newbie. Overwhelmed from all I've seen and tried out the last few days. My CMS of choice the last couple of years has been MODX. Other than that, I am working as a frontend and backend developer since over 10 years. Having so much freedom to work directly with PHP inside a CMS / CMF is a relief. No new pseudo scripting language one has to learn (as in Typo3), no unnecessary restrictions or bloat. So, my first general question: If I have an existing dataset in mySQL, that I would like to manage with PW (i.e. inside the admin area of PW) - how would I most likely do that? I know I could export the database tables to PW pages. But what if I wanted a database CRUD system inside the PW area? In MODX "Evo" you could build a custom module for such things. You know - phpMyAdmin is over the top for most clients, and an admin section with a different login and URL is clutter. How can I extend the PW backend? Is it possible to include an off-the shelf CRUD script somewhere? Is that not possible with PW? Or frowned upon? I'm just trying to see what the "best practises" are for these kinds of scenarios. Thanks for explanations, tips and pointers.
-
Which of the following are the minimum MySQL database user privileges required by ProcessWire? ALTER CREATE CREATE ROUTINE CREATE TEMPORARY TABLES CREATE VIEW DELETE DROP EXECUTE INDEX INSERT LOCK TABLES REFERENCES SELECT SHOW VIEW TRIGGER UPDATE
